>>>>> On Wed, 22 Feb 2006 13:30:58 -0500, William Reid <[EMAIL PROTECTED]> said: > > Just a few quick questions before we start testing. > > Is this necessary to keep the DB size at a norm?
I found it very necessary when using Postgres 7.3.4. It needs a full vacuum every week for me. > Will it hurt anything? Only performance on the server while it is running. > Has anyone setup a cronjob to handle this pre/post backup? Yes, I have an Admin job with a RunAfterJob specially for this. > Time - If anyone is currently doing this whats the average time it takes > for you database? And how large is your database? The problem is likely to be the File table and its indexes. On a 2.8HGz P4 with ~ 7 million rows in the File table, vacuum takes 30 mins and vacuum full takes 90 mins for me. I've not attempted to optimize this. __Martin ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users