Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] pg_freespacemap question - Mailing list pgsql-patches

From Tatsuo Ishii
Subject Re: [HACKERS] pg_freespacemap question
Date
Msg-id 20060312.101949.67879216.t-ishii@sraoss.co.jp
Whole thread Raw
In response to Re: [HACKERS] pg_freespacemap question  (Tatsuo Ishii <ishii@sraoss.co.jp>)
Responses Re: [HACKERS] pg_freespacemap question  (Mark Kirkwood <markir@paradise.net.nz>)
List pgsql-patches
Tree view 
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

pgsql-patches by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: [HACKERS] pg_freespacemap question
Next
From: Tom Lane
Date:
Subject: Proposed patch for error locations