| From: | Jim Nasby <decibel(at)decibel(dot)org> |
|---|---|
| To: | Chamara Gunaratne <chamarag(at)gmail(dot)com> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Disk and shared buffer cache use |
| Date: | 2007-05-09 23:39:59 |
| Message-ID: | 95544527-C970-48C0-854F-74436EB67B90@decibel.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
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(at)nasby(dot)net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Loredana Curugiu | 2007-05-10 07:15:17 | Re: Fw: Count rows group by time intervals |
| Previous Message | Jim Nasby | 2007-05-09 23:38:30 | Re: how to view the content of schema pg_catalog? |