Skip site navigation (1) Skip section navigation (2)

Re: [PATCHES] pg_freespacemap question

From: Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>
To: ishii(at)sraoss(dot)co(dot)jp
Cc: markir(at)paradise(dot)net(dot)nz, tgl(at)sss(dot)pgh(dot)pa(dot)us,alvherre(at)commandprompt(dot)com, peter_e(at)gmx(dot)net,pgsql-hackers(at)postgresql(dot)org, pgsql-patches(at)postgresql(dot)org
Subject: Re: [PATCHES] pg_freespacemap question
Date: 2006-03-12 01:19:49
Message-ID: 20060312.101949.67879216.t-ishii@sraoss.co.jp (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
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

In response to

Responses

pgsql-hackers by date

Next:From: David FetterDate: 2006-03-12 01:57:46
Subject: Re: psql -p 5433; create database test; \c test failing
Previous:From: Tatsuo IshiiDate: 2006-03-11 23:40:23
Subject: Re: pg_freespacemap question

pgsql-patches by date

Next:From: Tom LaneDate: 2006-03-12 17:37:35
Subject: Proposed patch for error locations
Previous:From: Tatsuo IshiiDate: 2006-03-11 23:40:23
Subject: Re: pg_freespacemap question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group