This is what we are doing today (except we are on Linux :) ). However, since there is talk of making autovacuum on by default and the advantages of having it run, it would be nice to be able to block out hours that it can not run. It would also be very nice to have the database take care of all of this via the config file and/or tables. That way, no external programs (cron or what ever) would be needed.
Even nicer would be to have the time exclusion granular enough to be table to exclude only certain tables. That way autovacuum can do it's work as needed on the majority of the tables, but tables that the DBA knows will cause problems during business hours could be excluded until the slow time.
Any comments on this?
Chris
On 4/11/06, Anthony Ransley <anthonyr@aurema.com> wrote:Hi Chris Hoover,
There is already a method for this! Can i suggest that you set a O/S
schedule to simple run vacuumdb.exe at the desired time, preferable late
evening, as the vacuum of large databases can take all night, based on
my DBA experience. Don't for get to setup the uses of password files, as
vacuumdb.exe will require a password and user account each end every
time it runs.
Anthony.
Chris Hoover wrote:
> I have an idea/request for the autovacuum daemon.
>
> 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?
>
> Thanks,
>
> Chris