Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id BFF761337B94 for ; Mon, 31 Jan 2011 14:58:15 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 72854-08 for ; Mon, 31 Jan 2011 18:58:08 +0000 (UTC) X-Greylist: delayed 00:30:20.810306 by SQLgrey-1.7.6 Received: from outmail149123.authsmtp.net (outmail149123.authsmtp.net [62.13.149.123]) by mail.postgresql.org (Postfix) with ESMTP id 29EC31336971 for ; Mon, 31 Jan 2011 14:58:07 -0400 (AST) Received: from mail-c187.authsmtp.com (mail-c187.authsmtp.com [62.13.128.33]) by punt6.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id p0VIRf0I031516; Mon, 31 Jan 2011 18:27:41 GMT Received: from Sidney-Stratton.local (dsl081-245-111.sfo1.dsl.speakeasy.net [64.81.245.111]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2) with ESMTP id p0VIRYmm043182; Mon, 31 Jan 2011 18:27:35 GMT Message-ID: <4D46FF15.7090606@agliodbs.com> Date: Mon, 31 Jan 2011 10:27:33 -0800 From: Josh Berkus User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-US; rv:1.9.1b3pre) Gecko/20090223 Thunderbird/3.0b2 MIME-Version: 1.0 To: Mark Kirkwood CC: Robert Haas , pgsql-performance@postgresql.org Subject: Re: Bloat issue on 8.3; autovac ignores HOT new pages? References: <4D3E34C8.9040209@agliodbs.com> <4D3F163E.100@agliodbs.com> <4D3F40BD.4040504@catalyst.net.nz> In-Reply-To: <4D3F40BD.4040504@catalyst.net.nz> Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Server-Quench: c68ffdd2-2d67-11e0-ab46-001185d377ca X-AuthReport-Spam: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-AuthRoute: OCdyZgscClZXSx8a IioLCC5HRQ8+YBZL BAkGMA9GIUINWEQK c1ABdx1xOVtbHwkA AnYKU15WV1dyXC1z bxRZbBtfZk9QXgRr T0pMQFdNFEsoAXp4 ZHdDDxl2dAROejBz YUdjECNdVBIsIRJ/ X0wAE2obZGY1aH1O AkReagNUcQJCe0tG bVcsBT1vNG8XDRoV JSEUBRUEdR9bLy1J CgAWNk8fCUENVm56 HENKFCgzGlMMTG0y IBohMFMHVGY2Dg00 PERpQVsXPgRFYgAA X-Authentic-SMTP: 61633136333939.1000:706 X-AuthFastPath: 0 (Was 255) X-AuthVirus-Status: No virus detected - but ensure you scan with your own anti-virus system. X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201101/345 X-Sequence-Number: 42132 Robert, Mark, I have not been able to reproduce this issue in a clean test on 9.0. As a result, I now think that it was related to the FSM being too small on the user's 8.3 instance, and will consider it resolved. -- -- Josh Berkus PostgreSQL Experts Inc. http://www.pgexperts.com