Thread: Buffer miss ratio

Buffer miss ratio

From

"崔岩ccuiyyan@sina.com"

Date:

01 January 2009, 05:00:52

Dear all:<br /><br />     A quick question about shared buffers in PostgreSQL: <br />     <br />     I want to get the
numberof misses for the buffer pool of PostgreSQL. Is there any methods or <br />     <br />     performance tools I
canuse to get the information?  <br /><br /><br /><br /><br /><br /><br
/>                                                                          <br
/>                                                                          <br />       
                                                                  Best Wishes<br /><br
/>                                                                                yyan<br />

Re: Buffer miss ratio

From

Heikki Linnakangas

Date:

01 January 2009, 05:08:36

崔岩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