On May 8, 2007, at 2:29 PM, Chamara Gunaratne wrote:
> Hello All,
> Is there a way to determine the percentage of data found in the shared
> buffer cache when running a query in PostgreSQL 7.4? Or to put it in
> another way, how do you measure the effectiveness of the shared buffer
> cache?
>
> I read through several sites on PostgreSQL performance tuning, but
> couldn't find a method to measure this.
> Thank you,
Look at the pg_statio_* views (you'll need block level stats enabled
in postgresql.conf).
Personally, I wouldn't worry too much about this unless you're trying
to chase some specific performance issue.
--
Jim Nasby jim@nasby.net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)