Postgres Pro
Downloads
Home   >   mailing lists

Re: Occupation bloc in pages of table - Mailing list pgsql-performance

From Tom Lane
Subject Re: Occupation bloc in pages of table
Date
Msg-id 16264.1151078981@sss.pgh.pa.us
Whole thread Raw
In response to Occupation bloc in pages of table  (luchot <luchot@voila.fr>)
List pgsql-performance
Tree view 
luchot <luchot@voila.fr> writes:
> I would want if it is possible for each pages of a table to have the occupation of blocs in percentage in order to
seeif the page is good full or not. 

There is not any magic way of getting that information, but you could
modify contrib/pgstattuple to produce such a report.

            regards, tom lane

pgsql-performance by date:

Previous
From: Markus Schaber
Date:
Subject: Re: Help tuning autovacuum - seeing lots of relationbloat
Next
From: Daniel Xavier de Sousa
Date:
Subject: Buffers to Nest Loop Join