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 5852511F620D for ; Tue, 11 Apr 2006 20:02:53 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: 0.642 X-Spam-Level: X-Spam-Status: No, score=0.642 required=5 tests=[HTML_00_10=0.642, 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 SLcMXhsa8dad for ; Tue, 11 Apr 2006 20:02:47 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from xproxy.gmail.com (xproxy.gmail.com [66.249.82.205]) by postgresql.org (Postfix) with ESMTP id 0F8C511F6247 for ; Tue, 11 Apr 2006 20:02:45 -0300 (ADT) Received: by xproxy.gmail.com with SMTP id h31so944060wxd for ; Tue, 11 Apr 2006 16:02:46 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=JMBTFcKRoa/XggZ/bN6NgkvLXGJkpgm6e7oK/J3HueGc/JskJTECyJTC2QqXt+auE4nyKVPtuaBPVgo+480UDUprnJuCs9A697iMPd3GRGjNCpHseZ5c+Cdni0Rl3ozelFCQXncCNGh3qSRsSnmSWKva8nF/CtJM9mhmrN0aOaE= Received: by 10.70.52.6 with SMTP id z6mr3093008wxz; Tue, 11 Apr 2006 16:02:45 -0700 (PDT) Received: by 10.70.87.13 with HTTP; Tue, 11 Apr 2006 16:02:45 -0700 (PDT) Message-ID: <1d219a6f0604111602m62445e60h425c5dd59219606e@mail.gmail.com> Date: Tue, 11 Apr 2006 19:02:45 -0400 From: "Chris Hoover" To: "pgsql-admin@postgresql.org" Subject: Autovacuum ideas MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_17411_4665937.1144796565755" X-Archive-Number: 200604/103 X-Sequence-Number: 21272 ------=_Part_17411_4665937.1144796565755 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 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_17411_4665937.1144796565755 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline I have an idea/request for the autovacuum daemon.

As far as I can te= ll, 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 ha= ve 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 dai= ly.  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 lik= e this?

Thanks,

Chris
------=_Part_17411_4665937.1144796565755--