Re: FSM fill ratio - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: FSM fill ratio
Date
Msg-id 20080426135045.GG10366@alvh.no-ip.org
Whole thread Raw
In response to FSM fill ratio  (Jacques Caron <jc@oxado.com>)
List pgsql-hackers
Jacques Caron wrote:
> Hi all,
>
> Quick question: is there currently a way to see how many slot are used in 
> the FSM (i.e. how many free pages are stored there), or how many are 
> free? If not, wouldn't it be a good idea to add this somewhere? (Don't 
> quite know where... is it possible to have very dynamic values in show 
> xxx?) This would help a lot finding out whether the current fsm settings 
> are fine or not...

There's contrib/pg_freespacemap

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Proposed patch - psql wraps at window width
Next
From: "Joshua D. Drake"
Date:
Subject: Re: we don't have a bugzilla