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

Collapse
Posted by Joel Aufrecht on
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?