Buffer miss ratio
Started by 崔岩ccuiyyan@sina.comabout 17 years ago2 messages
Dear all:
A quick question about shared buffers in PostgreSQL:
I want to get the number of misses for the buffer pool of PostgreSQL.
Is there any methods or
performance tools I can use to get the information?
Best Wishes
yyan
Re: Buffer miss ratio
崔岩ccuiyyan@sina.com wrote:
I want to get the number of misses for the buffer pool of PostgreSQL.
Is there any methods orperformance tools I can use to get the information?
Yes. Please see the manual chapters on "Monitoring database activity".
The pgstatio_* views in particular.
PS. This mailing list is for discussion on development of PostgreSQL.
Questions on usage belong to pgsql-general, or one of the other user
mailing lists.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com