>>>>> 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

Reply via email to