Re: Shared Buffer setting in postgresql.conf

From: Josh Trutwin <josh(at)trutwins(dot)homeip(dot)net>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Shared Buffer setting in postgresql.conf
Date: 2007-10-10 20:32:01
Message-ID: 20071010153201.65331672@joplin.trutwins.homeip.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Wed, 10 Oct 2007 10:20:02 -0500
"Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> wrote:

> In 7.4, using 25% is often too high a setting for it to handle well,
> and the practical useful maximum is usually under 10,000
> shared_buffers, and often closer to 1,000 to 5,000

Scott - interesting reply. Is this also true for 8.1? I currently
have mine set to 16384 - server has 3.5 GB of total memory.

Josh

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2007-10-10 20:32:57 Re: hashjoin chosen over 1000x faster plan
Previous Message Kevin Grittner 2007-10-10 20:11:48 Re: hashjoin chosen over 1000x faster plan