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 9686611F6202 for ; Tue, 11 Apr 2006 20:24:02 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: 0 X-Spam-Level: X-Spam-Status: No, score=0 required=5 tests=[none] Received: from postgresql.org ([200.46.204.71]) by localhost (mx2.hub.org [200.46.204.254]) (amavisd-new, port 10024) with ESMTP id CRXrLxcMkEBA for ; Tue, 11 Apr 2006 20:23:56 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from smtp.sw.oz.au (alt.aurema.com [203.217.18.57]) by postgresql.org (Postfix) with ESMTP id 0CFAD11F660B for ; Tue, 11 Apr 2006 20:23:53 -0300 (ADT) Received: from [192.41.203.74] (anthonyr.sw.oz.au [192.41.203.74]) by smtp.sw.oz.au with ESMTP id k3BNLIYv000279; Wed, 12 Apr 2006 09:21:18 +1000 (EST) Message-ID: <443C39ED.6050706@aurema.com> Date: Wed, 12 Apr 2006 09:21:17 +1000 From: Anthony Ransley User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Chris Hoover CC: "pgsql-admin@postgresql.org" Subject: Re: Autovacuum ideas References: <1d219a6f0604111602m62445e60h425c5dd59219606e@mail.gmail.com> In-Reply-To: <1d219a6f0604111602m62445e60h425c5dd59219606e@mail.gmail.com> Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 8bit X-Scanned-By: MIMEDefang 2.52 on 192.41.203.35 X-Archive-Number: 200604/104 X-Sequence-Number: 21273 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