>>>>> On Sun, 17 Sep 2006 20:27:37 -0400, Francisco Reyes said: > > My postgresql DB for bacula is 30GB with daily vacuum analyze and > autovacuum.. have lots of small files.. and have not even finished adding > all our servers to be managed by Bacula.
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 __Martin ------------------------------------------------------------------------- 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
