Re: Autovacuum ideas

Chris Hoover wrote:

> As far as I can tell, there is no way to tell the daemon to only do it's
> work between certain hours. Could this be added as an option? In my
> situation, I have tables that if vacuumed during the day would cause a
> noticeable slowdown to my users and has therefore been deemed unacceptable
> by management. This is one thing that is preventing me from turning on
> autovacuun,. However, due to the activity on them, they really need to be
> vacuumed daily. It would be nice to be able to tell autovacuum to run, but
> have a way to tell it to always sleep during these hours (i.e. 7am to 5pm
> daily). Has there been any thought into a feature like this?

Well, this is something that is (or should be) in the TODO list, but no
one has come around with a proposal to implement it yet. I've given it
tiny amounts of thought; a system not unlike Unix's crontab might do it.
You would specify intervals at which you wish autovacuum to operate on
certain groups of tables; or intervals at which you don't want autovac
to run at all, etc.

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.