Re: [HACKERS] FSM fill ratio

2008-04-26 Thread Alvaro Herrera 
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 Herrerahttp://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

[HACKERS] FSM fill ratio

2008-04-25 Thread Jacques Caron 

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.


--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers