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: [email protected]
Views: Whole Thread | Raw Message | 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 2009-01-01 09:00:45 Buffer miss ratio