Forum OpenACS Q&A: Re: best Postgres vacuum to do automatically

2: Re: best Postgres vacuum to do automatically (response to 1)

Posted by Roberto Mello on 04/30/03 08:18 AM

We should be recommending at least ANALYZE (by itself). If we are going to recommend VACUUM, we should recommend VACUUM ANALYZE once an hour (or so) and a VACUUM FULL ANALYZE once a night.

The Debian PostgreSQL packages include scripts to do this periodic maintenance. We could provide them in the newly created /etc directory or in the docs themselves.

-Roberto

3: Re: best Postgres vacuum to do automatically (response to 2)

Posted by Joel Aufrecht on 04/30/03 09:31 AM

Currently the docs describe using crontab to run a command to vacuum. It's quick and dirty and works reasonably well. As Lars pointed out on a related cron-type issue, it's not cross-platform and doesn't take advantage of OpenACS for logging/email/failsafe. Is the OpenACS cron-type package stable and usable? If so, we should start moving automated tasks to that in the default install. In the meantime, should I just add a second cron line (one for hourly vacuum analyze, one for nightly vacuum full analyze)? Is there an advantage to using the scripts?

Automated tasks include vacuuming in its various flavors, nightly database backup, nightly everything backup ... anything else? Notifications has regular jobs. search re-indexing is automatic. Do those use the cron package?