Postgres Pro
Downloads
Home   >   mailing lists

Re: How to determine if my setting for shared_buffers is too high? - Mailing list pgsql-performance

From Tom Lane
Subject Re: How to determine if my setting for shared_buffers is too high?
Date
Msg-id 16436.1165511080@sss.pgh.pa.us
Whole thread Raw
In response to How to determine if my setting for shared_buffers is too high?  (Bill Moran <wmoran@collaborativefusion.com>)
List pgsql-performance
Tree view 
Bill Moran <wmoran@collaborativefusion.com> writes:
> I haven't been able to find anything regarding how much of the
> shared buffer space PostgreSQL is actually using, as opposed to
> simply allocating.

In 8.1 and up, contrib/pg_buffercache/ would give you some visibility
of this.

            regards, tom lane

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Advice on selecting good values for work_mem?
Next
From: Stephen Frost
Date:
Subject: Re: Advice on selecting good values for work_mem?