update doc about indexes

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
 

diff --git a/docs/techlogs/speed-test-results.ods b/docs/techlogs/speed-test-results.ods
index 9551e83e4a9842b7f5bde13db98c6d984c62bdec..ac08f20c4c14cdb0d564fc4fd79c31a698850ba2 100644 (file)
Binary files a/docs/techlogs/speed-test-results.ods and b/docs/techlogs/speed-test-results.ods differ