I was under the impression that a full vacuum was more extensive and compacted the tables more than a regular vacuum.
I'll check out autovacuum, thanks. -Dan On 12/13/05, Jim C. Nasby <[EMAIL PROTECTED]> wrote: > 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 >
