Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 932341337B5E for ; Tue, 25 Jan 2011 14:28:54 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 26182-06 for ; Tue, 25 Jan 2011 18:28:47 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outmail149103.authsmtp.co.uk (outmail149103.authsmtp.co.uk [62.13.149.103]) by mail.postgresql.org (Postfix) with ESMTP id E75B7133616B for ; Tue, 25 Jan 2011 14:28:46 -0400 (AST) Received: from mail-c187.authsmtp.com (mail-c187.authsmtp.com [62.13.128.33]) by punt12.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id p0PISOXp022815; Tue, 25 Jan 2011 18:28:24 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 p0PISKt1051584; Tue, 25 Jan 2011 18:28:21 GMT Message-ID: <4D3F163E.100@agliodbs.com> Date: Tue, 25 Jan 2011 10:28:14 -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: Robert Haas CC: pgsql-performance@postgresql.org Subject: Re: Bloat issue on 8.3; autovac ignores HOT page splits? References: <4D3E34C8.9040209@agliodbs.com> In-Reply-To: Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Server-Quench: e3b5f611-28b0-11e0-ab46-001185d377ca X-AuthReport-Spam: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-AuthRoute: OCdyZgscClZXSx8a IioLCC5HRQ8+YBZL BAkGMA9GIUINWEQL c1AAcx1xOVtbHwkA AnYKU15WWFdzWy1z bxRZbBtfZk9QXgRr T0pMQFdNFEsoAXx4 ZWVaUxl3dgBOfDBz YURiECVYDkEsc0d8 X0xcR20bZGY1aH1O AkReagNUcQJCe0tG bVcsBT1vNG8XDRoV JSEUBRUEdR9bLy1J CgAWNk8fCUENVm56 HENKFCgzGlMMTG0y IBohMFMHVGY2Dg0q OFQsEUkANx4OEVo2 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 X-Spam-Level: X-Archive-Number: 201101/233 X-Sequence-Number: 42020 > Can we see those stats again with n_tup_ins/upd/del? Sure: -[ RECORD 2 ]----------+------------------------------ schemaname | public relname | general_info n_dead_tup | 12 n_live_tup | 1 n_tup_upd | 8817 n_tup_del | 0 n_tup_ins | 0 n_tup_hot_upd | 8817 pg_relation_size | 155648 pg_total_relation_size | 172032 -[ RECORD 4 ]----------+------------------------------ schemaname | public relname | current_info n_dead_tup | 27 n_live_tup | 1 n_tup_upd | 3296 n_tup_del | 0 n_tup_ins | 0 n_tup_hot_upd | 3296 pg_relation_size | 385024 pg_total_relation_size | 409600 One question: in 8.3 and earlier, is the FSM used to track dead_rows for pg_stat_user_tables? -- -- Josh Berkus PostgreSQL Experts Inc. http://www.pgexperts.com