Re: AutoVacuum on demand?

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