Re: Autovacuum ideas

On Wednesday 12 April 2006 07:53, Chris Hoover wrote:
> 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.

What about leaving autovac running, and poke values into the pg_autovacuum
table via cron?

>
>
> 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

--
Darcy Buskermolen
Wavefire Technologies Corp.

http://www.wavefire.com
ph: 250.717.0200
fx: 250.763.1759