Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 6C3A59FC12B for ; Thu, 7 Jun 2007 15:59:05 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 60153-01 for ; Thu, 7 Jun 2007 15:59:01 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from lists.commandprompt.com (host-254.commandprompt.net [207.173.203.254]) by postgresql.org (Postfix) with ESMTP id AF0CF9FC10B for ; Thu, 7 Jun 2007 15:59:01 -0300 (ADT) Received: from perhan.alvh.no-ip.org (201-221-217-243.bk12-dsl.surnet.cl [201.221.217.243]) (authenticated bits=0) by lists.commandprompt.com (8.13.7/8.13.6) with ESMTP id l57Ix1EY031319; Thu, 7 Jun 2007 11:59:02 -0700 Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id 73FB332A28; Thu, 7 Jun 2007 14:58:54 -0400 (CLT) Date: Thu, 7 Jun 2007 14:58:54 -0400 From: Alvaro Herrera To: Joe Lester Cc: pgsql-performance@postgresql.org Subject: Re: Getting Slow Message-ID: <20070607185854.GC21004@alvh.no-ip.org> References: <14D118F0-20F6-4096-93D7-E6CB2893E895@sweetwater.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <14D118F0-20F6-4096-93D7-E6CB2893E895@sweetwater.com> User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: ClamAV version 0.88.5, clamav-milter version 0.88.5 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]); Thu, 07 Jun 2007 11:59:02 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/139 X-Sequence-Number: 25172 Joe Lester wrote: > max_fsm_pages = 150000 This may be a bit too low -- it's just a little more than 1 GB, which means it might fail to keep track of all your tables (or it may not, if you don't have many updates). > autovacuum_naptime = 60 > autovacuum_vacuum_threshold = 150 > autovacuum_vacuum_scale_factor = 0.00000001 > autovacuum_analyze_scale_factor = 0.00000001 The scale factors seems awfully low. How about 0.01 instead and see if you avoid vacuuming all your tables with every iteration ... have you noticed how much work autovacuum is really doing? It may be too much. Also if autovacuum is eating all your I/O you may want to look into throttling it back a bit by setting autovacuum_vacuum_cost_delay to a non-zero value. -- Alvaro Herrera http://www.advogato.org/person/alvherre "La tristeza es un muro entre dos jardines" (Khalil Gibran)