From bb7147dbd7e8e466541687f2a5d38923aa87aca4 Mon Sep 17 00:00:00 2001 From: Eric Bollengier Date: Mon, 10 Nov 2008 10:45:03 +0000 Subject: [PATCH] ebl Add note about postgresql tuning --- docs/manuals/en/catalog/postgresql.tex | 10 ++++++++++ 1 file changed, 10 insertions(+) diff --git a/docs/manuals/en/catalog/postgresql.tex b/docs/manuals/en/catalog/postgresql.tex index 99091251..f688ff17 100644 --- a/docs/manuals/en/catalog/postgresql.tex +++ b/docs/manuals/en/catalog/postgresql.tex @@ -453,6 +453,16 @@ to modify the bacula.spec file to account for the new PostgreSQL version. You can do so by rebuilding from the source rpm. To do so, you may need install from rpms and you upgrade PostgreSQL, you must also rebuild Bacula. +\section{Tuning PostgreSQL} +\index[general]{Tuning} + +If you despool attributes for many jobs at the same time, you can tune the +sequence object for the \texttt{FileId} field. +\begin{verbatim} +psql -Ubacula bacula + +ALTER SEQUENCE file_fileid_seq CACHE 1000; +\end{verbatim} \section{Credits} \index[general]{Credits } -- 2.39.5