>>>>> On Mon, 6 Feb 2006 21:36:36 +0100, "Magnus Hagander" <[EMAIL PROTECTED]> >>>>> said: > > > OTOH, at least 15% of the 9 million rows in the File table > > are deleted (by > > pruning) and reinserted (by backup) every weekend. Within 2 > > months, almost 100% of the rows will have been deleted and reinserted. > > So run a VACUUM after each of those. Or just run a nightly VACUUM (or > maybe daily if you run the backups at night, but you get the idea). 15% > is fairly much, but that just means you need higher max_fsm_pages > (maybe, depends on db size).
Yes, that is what I've been doing. VACUUM without FULL didn't fix it. VACUUM with FULL takes about 90 mins, but keeps it almost under control. __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
