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. Has anyone devised a better method? -Dan
