Re: Buffer miss ratio - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: Buffer miss ratio
Date
Msg-id 495C880C.10609@enterprisedb.com
Whole thread Raw
In response to Buffer miss ratio  ("崔岩ccuiyyan@sina.com" <ccuiyyan@gmail.com>)
List pgsql-hackers
崔岩ccuiyyan@sina.com wrote:
>      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?

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


pgsql-hackers by date:

Previous
From: "崔岩ccuiyyan@sina.com"
Date:
Subject: Buffer miss ratio
Next
From: Heikki Linnakangas
Date:
Subject: Re: lazy_truncate_heap()