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 9FAD511F8876 for ; Fri, 14 Apr 2006 18:55:06 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: 1.047 X-Spam-Level: * X-Spam-Status: No, score=1.047 required=5 tests=[AWL=0.120, MSGID_FROM_MTA_ID=0.927] Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id MhiLqfhq3AzM for ; Fri, 14 Apr 2006 18:54:58 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sydney.mailnetwork.co.uk (server88-208-192-113.live-servers.net [88.208.192.113]) by postgresql.org (Postfix) with ESMTP id A746F11F86A9 for ; Fri, 14 Apr 2006 18:54:46 -0300 (ADT) Received: from andyshellam-gw.adsl.newnet.co.uk ([80.175.198.137]:2125 helo=acsdesk1) by sydney.mailnetwork.co.uk with esmtpa (Exim 4.60) (envelope-from ) id 1FUWFZ-0002C9-Ec; Fri, 14 Apr 2006 22:54:45 +0100 Reply-To: From: "Andy Shellam" To: "'Joshua D. Drake'" Cc: Subject: Re: Autovacuum ideas Date: Fri, 14 Apr 2006 22:54:37 +0100 Organization: the mail network MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook, Build 11.0.5510 In-Reply-To: <1144799436.13511.28.camel@localhost.localdomain> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 Thread-Index: AcZdw2rkeNl2PPkhSgS3LDoO/NSxMwCSnSHw Message-Id: <20060414215446.A746F11F86A9@postgresql.org> X-Archive-Number: 200604/133 X-Sequence-Number: 21302 The problem is the PG team are looking at making autovac compulsory (ie. You can't turn it off). I don't know when, might be in 8.2, but I know the issue has been discussed on the lists before. Andy -----Original Message----- From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Joshua D. Drake Sent: Wednesday, 12 April, 2006 12:51 am To: Chris Hoover Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Autovacuum ideas > 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/ ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend !DSPAM:14,443c41f433694226768114!