Thanks guys, you comments are much appreciated. My background is
mainly in network performance evaluation and I am new to db tuning. I
will enable block level stats and get the data.
The reason I am looking for this data is that I am debugging a very
slow db server. CPU wait time % is over 50% and it is constantly
reading in MB's of data (vmstat bi column). I have shared buffers at
128MB and effective cache size at 256MB. and the db size is around
1.5GB. I am guessing that the db working set is much larger than
available cache memory.
On 5/9/07, Jim Nasby <decibel(at)decibel(dot)org> wrote:
> 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)
Priyanga Chamara Gunaratne
In response to
pgsql-novice by date
|Next:||From: chester c young||Date: 2007-05-10 18:34:22|
|Subject: Re: Count rows by day interval|
|Previous:||From: Richard Broersma Jr||Date: 2007-05-10 15:33:55|
|Subject: Re: Count rows group by time intervals|