Remember that as you increase shared_buffers you might need to make the
bgwriter more aggressive too.
On Thu, Dec 07, 2006 at 11:42:39AM -0500, Bill Moran wrote:
>
> I'm gearing up to do some serious investigation into performance for
> PostgreSQL with regard to our application. I have two issue
Bill Moran <[EMAIL PROTECTED]> 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.
reg
I'm gearing up to do some serious investigation into performance for
PostgreSQL with regard to our application. I have two issues that I've
questions about, and I'll address them in two seperate emails.
This one regards tuning shared_buffers.
I believe I have a good way to monitor database acti