Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 13A3D632FE0 for ; Wed, 11 Feb 2009 13:04:00 -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 56960-05-2 for ; Wed, 11 Feb 2009 13:03:55 -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 CF759632FE7 for ; Wed, 11 Feb 2009 13:03:55 -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 1LXIOz-0008Dk-BR; Wed, 11 Feb 2009 16:57:33 +0000 Message-ID: From: "John Lister" To: "Rajesh Kumar Mallah" , "Tom Lane" Cc: References: <2BB7361E57C4417A975C0474610BA4C3@squarepi.com> <27759.1229521625@sss.pgh.pa.us> Subject: Re: controlling autovacuum during the day. Date: Wed, 11 Feb 2009 16:31:55 -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=0.001 tagged_above=0 required=5 tests=STOX_REPLY_TYPE=0.001 X-Spam-Level: X-Archive-Number: 200902/73 X-Sequence-Number: 31294 Sounds like a good idea and i think i think more control of the autovacuum process has been discussed here recently. As to my initial problem, i eventually solved it. One of my colleagues was using a full table lock despite denying it originally, this was causing the problem. Took some tracking down as it the culprit statement always looked like an update hence my original questions.. Autovacuum running again fine now and i've even tuned it down a bit as suggested which was a new feature for me Thanks for all your help. JOHN ----- Original Message ----- From: "Rajesh Kumar Mallah" To: "Tom Lane" Cc: "John Lister" ; Sent: Wednesday, February 11, 2009 3:37 PM Subject: Re: [ADMIN] controlling autovacuum during the day. > On Wed, Dec 17, 2008 at 7:17 PM, Tom Lane wrote: >> "John Lister" writes: >>> 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? >> >> No. Instead, set the vacuum cost parameters to make it run slow enough >> to not interfere too much with your work. > > is it a bad idea to have such a feature ? > i was going through ./src/backend/postmaster/autovacuum.c > looks like subroutine autovac_start can be modfied to > for the said feature. In case it does not have negative implication > can i submit a patch ? > > regds > -- mallah. > > >> >> regards, tom lane >> >> -- >> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-admin >> > > -- > Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin >