Why are you running vacuum full? There shouldn't be any need to if you're vacuuming regularly enough. Your best bet is to use autovacuum.
What version of PostgreSQL are you using? On Tue, Dec 13, 2005 at 04:50:43PM -0500, Dan wrote: > I am running Bayes, AWL, and userprefs on postgres and have VACUUM > ANALYZE run nightly via cron. I have been running a full vacuum > manually once every other week, but I would like to use a cron script. > The problem is that the database has to be locked while it is run. > > The best idea that I was able to come up with is a script that > restarts SA with a .cf file that disables Bayes and AWL while > vacuuming and then restarts SA with the normal config. Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
