X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx2.hub.org [200.46.204.254]) by postgresql.org (Postfix) with ESMTP id 8FE1711F606B for ; Wed, 12 Apr 2006 11:54:01 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: -0.303 X-Spam-Level: X-Spam-Status: No, score=-0.303 required=5 tests=[AWL=0.945, BAYES_00=-2.599, HTML_10_20=1.351, HTML_MESSAGE=0.001, SPF_PASS=-0.001] Received: from postgresql.org ([200.46.204.71]) by localhost (mx2.hub.org [200.46.204.254]) (amavisd-new, port 10024) with ESMTP id zgay7ukknVVS for ; Wed, 12 Apr 2006 11:53:56 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from xproxy.gmail.com (xproxy.gmail.com [66.249.82.193]) by postgresql.org (Postfix) with ESMTP id 6DC9E11F6931 for ; Wed, 12 Apr 2006 11:53:52 -0300 (ADT) Received: by xproxy.gmail.com with SMTP id h31so1048504wxd for ; Wed, 12 Apr 2006 07:53:53 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=EfOfryee7Y2uWgwmHy7dljk1P9CCssqpX+H6awHYdOkjxwrWKWNYGsDZg7IqbdsQ46uncZYQat2/ejHenBRU2qwqBDERvm5FoJ3N8vRKlXkE6Wy5H13MY3rqYJMg/aeQWT4Z91oGQZ8PhjGJ/gE3+ia0lveycrQgJPjIjshjFsc= Received: by 10.70.45.3 with SMTP id s3mr2267136wxs; Wed, 12 Apr 2006 07:53:51 -0700 (PDT) Received: by 10.70.87.13 with HTTP; Wed, 12 Apr 2006 07:53:51 -0700 (PDT) Message-ID: <1d219a6f0604120753h1cabb4c2n60f53403225dcf81@mail.gmail.com> Date: Wed, 12 Apr 2006 10:53:51 -0400 From: "Chris Hoover" To: "Anthony Ransley" Subject: Re: Autovacuum ideas Cc: "pgsql-admin@postgresql.org" In-Reply-To: <443C39ED.6050706@aurema.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_4279_29359082.1144853631965" References: <1d219a6f0604111602m62445e60h425c5dd59219606e@mail.gmail.com> <443C39ED.6050706@aurema.com> X-Archive-Number: 200604/108 X-Sequence-Number: 21277 ------=_Part_4279_29359082.1144853631965 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 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 o= f 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 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 > > > ------=_Part_4279_29359082.1144853631965 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 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 c= an 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 exter= nal programs (cron or what ever) would be needed.

Even nicer would be to have the time exclusion granular enough to b= e 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 kn= ows will cause problems during business hours could be excluded until the s= low time.


Any comments on this?

Chris

On 4/11/06, Anthony Ransley &= lt;anthonyr@aurema.com> wrote= :
Hi Chris Hoover,<= br>

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 lat= e
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, a= s
vacuumdb.exe will require a password and user account each end everytime it runs.

Anthony.

Chris Hoover wrote:

> I hav= e an idea/request for the autovacuum daemon.
>
> As far as I ca= n 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 wou= ld
> cause a noticeable slowdown to my users and has therefore been d= eemed
> unacceptable by management. This is one thing that is preventing m= e
> from turning on autovacuun,. However, due to the activity on them= ,
> they really need to be vacuumed daily. It would be nice to be abl= e to
> tell autovacuum to run, but have a way to tell it to always sleep<= br>> during these hours ( i.e. 7am to 5pm daily). Has there been any
= > thought into a feature like this?
>
> Thanks,
>
> Chris



------=_Part_4279_29359082.1144853631965--