Glen Parker wrote:
I would like a way to run the autovacuum daemon on demand periodically. Every night at 2 AM, for example.Anybody know if this is possible? If not, it's a feature request :-)
Autovacuum can be enabled / disabled on the fly using the GUC settings. Perhaps you can write a cron script that runs at 2AM that enables autovac, and at 6AM (just a guess) disables it in the same fashion. I think that should work.
Would be curious to hear your results. Matt
