From 9ad2f9cea83063a127e59a2cb0943fdbeec57756 Mon Sep 17 00:00:00 2001 From: Eric Bollengier Date: Mon, 10 Nov 2008 10:23:14 +0000 Subject: [PATCH] ebl Add tips for big postgresql setup git-svn-id: https://bacula.svn.sourceforge.net/svnroot/bacula/trunk@8025 91ce42f0-d328-0410-95d8-f526ca767f89 --- bacula/src/cats/make_postgresql_tables.in | 5 +++++ bacula/technotes-2.5 | 3 +++ 2 files changed, 8 insertions(+) diff --git a/bacula/src/cats/make_postgresql_tables.in b/bacula/src/cats/make_postgresql_tables.in index 324300df69..051a17588c 100644 --- a/bacula/src/cats/make_postgresql_tables.in +++ b/bacula/src/cats/make_postgresql_tables.in @@ -43,6 +43,11 @@ CREATE TABLE file CREATE INDEX file_jobid_idx on file (jobid); CREATE INDEX file_fp_idx on file (filenameid, pathid); +-- +-- Add this if you have a good number of job +-- that run at the same time +-- ALTER SEQUENCE file_fileid_seq CACHE 1000; + -- -- Possibly add one or more of the following indexes -- if your Verifies are too slow. diff --git a/bacula/technotes-2.5 b/bacula/technotes-2.5 index e996a0c41e..e33c92717d 100644 --- a/bacula/technotes-2.5 +++ b/bacula/technotes-2.5 @@ -10,6 +10,9 @@ filepattern (restore with regex in bsr) mixed priorities General: +10Nov08 +ebl Add tips for postgresql to improve performance when having + multiple batch insert at the same time. 09Nov08 ebl Remove extra debug for db lock. 07Nov08 -- 2.39.5