Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 4C19F64FD3B for ; Wed, 17 Dec 2008 08:56:54 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 68062-07 for ; Wed, 17 Dec 2008 08:56:51 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.kickstone.com (smtp.kickstone.com [87.194.183.70]) by mail.postgresql.org (Postfix) with ESMTP id 5F8C864FD44 for ; Wed, 17 Dec 2008 08:56:51 -0400 (AST) Received: from madras2.square-pi.com ([192.168.2.131] helo=MADRAS2) by mail.kickstone.com with esmtpa (Exim 4.69) (envelope-from ) id 1LCvxJ-00033F-Cs for pgsql-admin@postgresql.org; Wed, 17 Dec 2008 12:56:49 +0000 Message-ID: <2BB7361E57C4417A975C0474610BA4C3@squarepi.com> From: "John Lister" To: Subject: Re: controlling autovacuum during the day. Date: Wed, 17 Dec 2008 12:56:49 -0000 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.5512 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5512 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.198 tagged_above=0 required=5 tests=FAKE_REPLY_C=2.197, STOX_REPLY_TYPE=0.001 X-Spam-Level: ** X-Archive-Number: 200812/122 X-Sequence-Number: 30955 I'd like to use autovacuum to clean up the tables rather than schedule a full vacuum with cron as it will be more selective/intelligent about what gets cleaned. But is it possible to stop it running during peak/office hours? I've seen a post mention using pg_autovacuum.enabled to do this, but this appears to be on a per table basis... I'd like to do this across the board, without restarting the db. Is this possible or do i need to insert every table into pg_autovacuum and run a script that sets the enabled flag as appropriate? Thanks -- Got needs? Get Goblin'! - http://www.pricegoblin.co.uk/