Re: Autovacuum ideas

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(at)aurema(dot)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
>
>
>