崔岩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 Linnakangas | Date: 2009-01-01 10:00:41 |
| Subject: Re: lazy_truncate_heap() |
| Previous: | From: 崔岩ccuiyyan | Date: 2009-01-01 09:00:45 |
| Subject: Buffer miss ratio |