Skip site navigation (1) Skip section navigation (2)

Re: Buffer miss ratio

From: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
To: "崔岩ccuiyyan(at)sina(dot)com" <ccuiyyan(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Buffer miss ratio
Date: 2009-01-01 09:08:28
Message-ID: 495C880C.10609@enterprisedb.com (view raw or flat)
Thread:
Lists: pgsql-hackers
崔岩ccuiyyan(at)sina(dot)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

In response to

pgsql-hackers by date

Next:From: Heikki LinnakangasDate: 2009-01-01 10:00:41
Subject: Re: lazy_truncate_heap()
Previous:From: 崔岩ccuiyyanDate: 2009-01-01 09:00:45
Subject: Buffer miss ratio

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group