From 1ef0fad86fabb962bc1b04190455672266855ebd Mon Sep 17 00:00:00 2001 From: Eric Bollengier Date: Sun, 6 Jan 2008 15:47:20 +0000 Subject: [PATCH] ebl Do some postgresql optimizations with advices from marc. git-svn-id: https://bacula.svn.sourceforge.net/svnroot/bacula/trunk@6244 91ce42f0-d328-0410-95d8-f526ca767f89 --- bacula/src/cats/make_postgresql_tables.in | 2 ++ bacula/technotes-2.3 | 3 +++ 2 files changed, 5 insertions(+) diff --git a/bacula/src/cats/make_postgresql_tables.in b/bacula/src/cats/make_postgresql_tables.in index ce6bbdc285..599a4a3063 100644 --- a/bacula/src/cats/make_postgresql_tables.in +++ b/bacula/src/cats/make_postgresql_tables.in @@ -14,6 +14,7 @@ CREATE TABLE filename primary key (filenameid) ); +ALTER TABLE filename ALTER COLUMN name SET STATISTICS 1000; CREATE INDEX filename_name_idx on filename (name); CREATE TABLE path @@ -23,6 +24,7 @@ CREATE TABLE path primary key (pathid) ); +ALTER TABLE path ALTER COLUMN path SET STATISTICS 1000; CREATE INDEX path_name_idx on path (path); CREATE TABLE file diff --git a/bacula/technotes-2.3 b/bacula/technotes-2.3 index 6b112fa4af..f2a8c8a18d 100644 --- a/bacula/technotes-2.3 +++ b/bacula/technotes-2.3 @@ -2,6 +2,9 @@ General: 06Jan08 +ebl Change default statistics target of filename.name and path.path + fields for PostgreSQL. This speeds lookup by indexes. Thanks + to Marc Cousin. kes A few more tweaks to new reservation code. Make sure to clear vol released flag when retaking volume. When reading label and label is bad mark volume unused. When recycling, mark volume -- 2.39.5