update doc about indexes

[bacula/docs] / docs / manuals / en / catalog / catmaintenance.tex

diff --git a/docs/manuals/en/catalog/catmaintenance.tex b/docs/manuals/en/catalog/catmaintenance.tex
index ee0be08cdd96fbe99f499a1dc98d94c8f392ad2c..da243b0c7b33713eeb904b09ea92093f1d3608b7 100644 (file)
--- a/docs/manuals/en/catalog/catmaintenance.tex
+++ b/docs/manuals/en/catalog/catmaintenance.tex
@@ -369,10 +369,10 @@ Several users have reported finding that their database did not have
 all the indexes in the default configuration.  In addition, you may
 find that because of your own usage patterns, you need additional indexes.
 
-The most important indexes for performance are the three indexes on the
+The most important indexes for performance are the two indexes on the
 {\bf File} table.  The first index is on {\bf FileId} and is automatically
 made because it is the unique key used to access the table.  The other
-two are the JobId index and the (Filename, PathId) index.  If these Indexes
+one is the (JobId, PathId, Filename) index.  If these Indexes
 are not present, your performance may suffer a lot.
 
 \subsection{PostgreSQL Indexes}
@@ -393,7 +393,7 @@ are created, you can create the two additional indexes using:
 \begin{verbatim}
 psql bacula
 CREATE INDEX file_jobid_idx on file (jobid);
-CREATE INDEX file_fp_idx on file (filenameid, pathid);
+CREATE INDEX file_fp_idx on file (jobid, pathid, filenameid);
 \end{verbatim}
 \normalsize
 
@@ -466,7 +466,7 @@ create them with the following commands:
 \begin{verbatim}
 sqlite <path>/bacula.db
 CREATE INDEX file_jobid_idx on File (JobId);
-CREATE INDEX file_jfp_idx on File (JobId, FilenameId, PathId);
+CREATE INDEX file_jfp_idx on File (JobId, PathId, FilenameId);
 \end{verbatim}
 \normalsize