Обсуждение: FSM fill ratio

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...

Thanks,

Jacques.

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