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

Re: [PATCHES] pg_freespacemap question

From: Mark Kirkwood <markir(at)paradise(dot)net(dot)nz>
To: Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>
Cc: 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 22:48:33
Message-ID: 4414A541.1080909@paradise.net.nz (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
Tatsuo Ishii wrote:
> 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?

I would have thought so - unless there are not enough pages left in the 
FSM...

pg_freespacemap is reporting on what gets into the FSM - so provided I 
haven't put a bug in there somewhere (!) - we need to look at how VACUUM 
reports free space to the FSM....

cheers

Mark

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2006-03-13 00:43:11
Subject: Re: [PATCHES] pg_freespacemap question
Previous:From: Josh BerkusDate: 2006-03-12 19:08:16
Subject: Re: PostgreSQL Anniversary Summit, Call for

pgsql-patches by date

Next:From: Tom LaneDate: 2006-03-13 00:43:11
Subject: Re: [PATCHES] pg_freespacemap question
Previous:From: Volkan YAZICIDate: 2006-03-12 17:59:10
Subject: Re: psql patch: new host/port without leaving session

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