Received: from localhost (maia-4.hub.org [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id E34509FB87D
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Fri, 16 Mar 2007 02:41:59 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024)
	with ESMTP id 47995-09 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Fri, 16 Mar 2007 02:41:56 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
Received: from mail3.plesk.ru (gw-swsoft2.ll-nsk.zsttk.ru [82.200.65.190])
	by postgresql.org (Postfix) with ESMTP id 6AEA09FB820
	for <pgsql-performance@postgresql.org>;
	Fri, 16 Mar 2007 02:41:56 -0300 (ADT)
Received: by mail3.plesk.ru (Postfix, from userid 426)
	id 9775B1A9BE2; Fri, 16 Mar 2007 11:41:54 +0600 (NOVT)
Received: from romanchuk.plesk.ru (romanchuk.plesk.ru [192.168.62.25])
	by mail3.plesk.ru (Postfix) with ESMTP id 732C61A9BAB
	for <pgsql-performance@postgresql.org>;
	Fri, 16 Mar 2007 11:41:54 +0600 (NOVT)
Date: Fri, 16 Mar 2007 11:41:50 +0600
From: Alexey Romanchuk <aromanchuk@swsoft.com>
X-Mailer: The Bat! (v3.5) Professional
Reply-To: aromanchuk@swsoft.com
X-Priority: 3 (Normal)
Message-ID: <17410023575.20070316114150@swsoft.com>
To: pgsql-performance@postgresql.org
Subject: Re: Determine dead tuples size
In-Reply-To: <20070315114508.GA12266@winnie.fuhr.org>
References: <24499713.20070315135847@swsoft.com>
	<20070315114508.GA12266@winnie.fuhr.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200703/251
X-Sequence-Number: 23656

Hello, Michael.

> On Thu, Mar 15, 2007 at 01:58:47PM +0600, Alexey Romanchuk wrote:
>> is it possible to determine dead tuples size for table?

> See contrib/pgstattuple.

thanks, i install contribs and try to analyze result of pgstattuple
function and found it strange.

Here it is output:
                             pgstattuple
----------------------------------------------------------------------
 (233242624,1186804,206555428,88.56,20707,3380295,1.45,13896816,5.96)

When i try to sum all size (live, dead and free) the sum is not equal
total size. For this table 206555428 + 3380295 + 13896816 = 223832539.
The difference between total and sum is 9410085. It is near 5%.

Is it ok?

-- 
Alexey Romanchuk