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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-hackers by date

  From Date Subject
Next Message Heikki Linnakangas 2009-01-01 10:00:41 Re: lazy_truncate_heap()
Previous Message 崔岩ccuiyyan 2009-01-01 09:00:45 Buffer miss ratio