Martin Simmons writes: > With some versions of PostgreSQL, you might find it useful to reindex all the > file table indexes regularly too, i.e. > > file_filenameid_idx > file_jobid_idx > file_jpfid_idx > file_pathid_idx > file_pkey
Will give that a try, but I thought reindexing was not needed on the 8.1.X branch (using 8.1.3). Will give it a try tonight and see if it helps. I do daily vacuum analyze and have autovacuum... we just have lots of records. ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
