Horton
Menu

Re: [PATCHES] pg_freespacemap question

Tatsuo Ishii <ishii@sraoss.co.jp>

View thread
From: Tatsuo Ishii <ishii@sraoss.co.jp>
To: ishii@sraoss.co.jp
Cc: markir@paradise.net.nz, tgl@sss.pgh.pa.us, alvherre@commandprompt.com, peter_e@gmx.net, pgsql-hackers@postgresql.org, pgsql-patches@postgresql.org
Date: 2006-03-12T01:19:49Z
Lists: pgsql-hackers 
BTW, I noticed difference of outputs from pg_freespacemap and
pgstattuple.

I ran pgbench and inspected "accounts" table by using these tools.

pg_freespacemap:
	sum of bytes: 250712

pgstattuple:
	free_space: 354880

Shouldn't they be identical?
--
Tatsuo Ishii
SRA OSS, Inc. Japan