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