Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 19C8D9FA060 for ; Tue, 21 Aug 2007 18:54:49 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 89162-07 for ; Tue, 21 Aug 2007 18:54:41 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from lists.commandprompt.com (host-254.commandprompt.net [207.173.203.254]) by postgresql.org (Postfix) with ESMTP id 18F3E9FA04A for ; Tue, 21 Aug 2007 18:54:44 -0300 (ADT) Received: from perhan.alvh.no-ip.org (201-221-221-172.bk12-dsl.surnet.cl [201.221.221.172]) (authenticated bits=0) by lists.commandprompt.com (8.13.7/8.13.6) with ESMTP id l7LLsroY012938; Tue, 21 Aug 2007 14:54:53 -0700 Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id DB9CE47C5B; Tue, 21 Aug 2007 17:54:41 -0400 (CLT) Date: Tue, 21 Aug 2007 17:54:41 -0400 From: Alvaro Herrera To: Sachchida Ojha Cc: Michael Glaesemann , pgsql-performance@postgresql.org Subject: Re: Autovacuum is running forever Message-ID: <20070821215441.GA12717@alvh.no-ip.org> References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.16 (2007-06-11) X-Virus-Scanned: ClamAV 0.91.1/4018/Tue Aug 21 03:42:09 2007 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (lists.commandprompt.com [192.168.2.159]); Tue, 21 Aug 2007 14:54:54 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/219 X-Sequence-Number: 26349 Sachchida Ojha wrote: > vacuum_cost_delay = 200 That is absurdly high. A setting of 10 is more likely to be useful. > autovacuum_naptime = 3600 That is too high probably as well; particularly so if you have "updates and deletes every second". > #autovacuum_vacuum_scale_factor = 0.4 > #autovacuum_analyze_scale_factor = 0.2 These too. Try 0.1 for both and see how it goes. In short, you need autovacuum to run _way more often_ than you are. -- Alvaro Herrera http://www.advogato.org/person/alvherre "Un poeta es un mundo encerrado en un hombre" (Victor Hugo)