pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedOccupation bloc in pages of table
5+ messages / 2 participants
[nested] [flat]
* Occupation bloc in pages of table
@ 2006-06-23 10:12 luchot <luchot@voila.fr>
0 siblings, 1 reply; 5+ messages in thread
From: luchot @ 2006-06-23 10:12 UTC (permalink / raw)
To: pgsql-performance
Hello,
I see in the documentation that we can obtain the number of pages for a table with the view named pg_class.
I would want if it is possible for each pages of a table to have the occupation of blocs in percentage in order to see if the page is good full or not.
I don’t find anything in the doc and the archive.
Best regards,
Sorry for my english
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Occupation bloc in pages of table
@ 2006-06-23 16:09 Tom Lane <tgl@sss.pgh.pa.us>
parent: luchot <luchot@voila.fr>
0 siblings, 0 replies; 5+ messages in thread
From: Tom Lane @ 2006-06-23 16:09 UTC (permalink / raw)
To: luchot@voila.fr; +Cc: pgsql-performance
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 see if 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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Occupation bloc in pages of table
@ 2006-06-26 07:52 luchot <luchot@voila.fr>
0 siblings, 0 replies; 5+ messages in thread
From: luchot @ 2006-06-26 07:52 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-performance
Thank you for you quick answer i will try to see what i can do whith the file contrib/pgstattuple
Best regards,
> Message du 23/06/06 à 18h11
> De : "Tom Lane" <tgl@sss.pgh.pa.us>
> A : luchot@voila.fr
> Copie à : pgsql-performance@postgresql.org
> Objet : Re: [PERFORM] Occupation bloc in pages of table
>
> 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 see if 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Occupation bloc in pages of table
@ 2006-06-26 08:03 luchot <luchot@voila.fr>
0 siblings, 0 replies; 5+ messages in thread
From: luchot @ 2006-06-26 08:03 UTC (permalink / raw)
To: pgsql-performance; tgl@sss.pgh.pa.us
Thank you for you quick answer i will try to see what i can do whith the file contrib/pgstattuple
Best regards,
> Message du 23/06/06 à 18h11
> De : "Tom Lane" <tgl@sss.pgh.pa.us>
> A : luchot@voila.fr
> Copie à : pgsql-performance@postgresql.org
> Objet : Re: [PERFORM] Occupation bloc in pages of table
>
> 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 see if 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Occupation bloc in pages of table
@ 2006-06-26 08:07 luchot <luchot@voila.fr>
0 siblings, 0 replies; 5+ messages in thread
From: luchot @ 2006-06-26 08:07 UTC (permalink / raw)
To: pgsql-performance
> De : "Tom Lane" <tgl@sss.pgh.pa.us>
> There is not any magic way of getting that information, but you could
> modify contrib/pgstattuple to produce such a report.
Thank you for you speed answer , i will try to see what i can do in contrib/pgstattuple
Best regards,
Luc
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2006-06-26 08:07 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-06-23 10:12 Occupation bloc in pages of table luchot <luchot@voila.fr>
2006-06-23 16:09 ` Tom Lane <tgl@sss.pgh.pa.us>
2006-06-26 07:52 Re: Occupation bloc in pages of table luchot <luchot@voila.fr>
2006-06-26 08:03 Re: Occupation bloc in pages of table luchot <luchot@voila.fr>
2006-06-26 08:07 Re: Occupation bloc in pages of table luchot <luchot@voila.fr>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox