From 9d965508e1cb080aa02f6e7c63a449cc525084eb Mon Sep 17 00:00:00 2001 From: Eric Bollengier Date: Tue, 24 Nov 2009 20:45:26 +0100 Subject: [PATCH] update --- docs/manuals/en/main/catmaintenance.tex | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) diff --git a/docs/manuals/en/main/catmaintenance.tex b/docs/manuals/en/main/catmaintenance.tex index da243b0c..b22208e8 100644 --- a/docs/manuals/en/main/catmaintenance.tex +++ b/docs/manuals/en/main/catmaintenance.tex @@ -393,10 +393,12 @@ 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 (jobid, pathid, filenameid); +CREATE INDEX file_jpf_idx on file (jobid, pathid, filenameid); \end{verbatim} \normalsize +Make sure that you doesn't have an index on File (filenameid, pathid). + \subsection{MySQL Indexes} On MySQL, you can check if you have the proper indexes by: -- 2.39.5