X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 48E719FA3AF for ; Wed, 21 Jun 2006 19:36:39 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 60125-07 for ; Wed, 21 Jun 2006 19:36:33 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id 9E17F9FA322 for ; Wed, 21 Jun 2006 19:36:31 -0300 (ADT) Received: by noel.decibel.org (Postfix, from userid 1001) id CDAB7564A7; Wed, 21 Jun 2006 17:11:50 -0500 (CDT) Received: (hashcash-sendmail, from uid 1001); Wed, 21 Jun 2006 17:11:50 -0500 Date: Wed, 21 Jun 2006 17:11:50 -0500 From: "Jim C. Nasby" To: jody brownell Cc: Csaba Nagy , postgres performance list Subject: Re: Help tuning autovacuum - seeing lots of relationbloat Message-ID: <20060621221150.GN93655@pervasive.com> References: <200606211052.43227.jody.brownell@q1labs.com> <200606211321.06253.jody.brownell@q1labs.com> <20060621193823.GI93655@pervasive.com> <200606211641.45674.jody.brownell@q1labs.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <200606211641.45674.jody.brownell@q1labs.com> X-Operating-System: FreeBSD 6.0-RELEASE-p4 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.11 X-Hashcash: 1:20:060621:jody.brownell@q1labs.com::Xeo5abvkY8wc39Rd:0000000000000 0000000000000000000000001YCc X-Hashcash: 1:20:060621:nagy@ecircle-ag.com::wFFMsQfPv8COCNme:000000000000000000 0000000000000000000000002YkS X-Hashcash: 1:20:060621:pgsql-performance@postgresql.org::rCZlt/ICIpSisLIi:00000 0000000000000000000000000b2m X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/424 X-Sequence-Number: 19781 On Wed, Jun 21, 2006 at 04:41:45PM -0300, jody brownell wrote: > BTW, in production with a similar load - autovacuum with default out of the box > settings seems to work quite well.... > > I double checked this earlier today. So what's different between production and the machine with the problem? The issue with autovac is that it will only vacuum one table at a time, so if it's off vacuuming some other table for a long period of time it won't be touching this table, which will be a problem. Now, if that's actually what's happening... -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461