X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 75B8411F7DB1 for ; Tue, 11 Apr 2006 20:50:44 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: 0.11 X-Spam-Level: X-Spam-Status: No, score=0.11 required=5 tests=[AWL=0.110] Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id YKaJEXRILQg8 for ; Tue, 11 Apr 2006 20:50:29 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from projects.commandprompt.com (host-130.commandprompt.net [207.173.203.130]) by postgresql.org (Postfix) with ESMTP id 3E06611F7D94 for ; Tue, 11 Apr 2006 20:50:36 -0300 (ADT) Received: from [192.168.15.100] (or-67-76-146-141.sta.sprint-hsd.net [67.76.146.141]) (authenticated bits=0) by projects.commandprompt.com (8.13.4/8.13.4) with ESMTP id k3BNoc1C010665; Tue, 11 Apr 2006 16:50:39 -0700 Subject: Re: Autovacuum ideas From: "Joshua D. Drake" To: Chris Hoover Cc: "pgsql-admin@postgresql.org" In-Reply-To: <1d219a6f0604111602m62445e60h425c5dd59219606e@mail.gmail.com> References: <1d219a6f0604111602m62445e60h425c5dd59219606e@mail.gmail.com> Content-Type: text/plain Organization: Command Prompt, Inc. Date: Tue, 11 Apr 2006 16:50:36 -0700 Message-Id: <1144799436.13511.28.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.6.1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: ClamAV version 0.88, clamav-milter version 0.87 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (projects.commandprompt.com [192.168.2.159]); Tue, 11 Apr 2006 16:50:39 -0700 (PDT) X-Archive-Number: 200604/105 X-Sequence-Number: 21274 > 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? Well... just turn off autovac and then use vacuumdb during off hours via cron. Joshua D. Drake > > Thanks, > > Chris -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/