From: Scott Marlowe <scott.marlowe@gmail.com>
To: Josh Trutwin <josh@trutwins.homeip.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: Shared Buffer setting in postgresql.conf
Date: Wed, 10 Oct 2007 15:58:54 -0500
Message-ID: <dcc563d10710101358p55abb925pba894a693b21718f@mail.gmail.com> (raw)
In-Reply-To: <20071010153201.65331672@joplin.trutwins.homeip.net>
References: <fe27bfd40710091312l1d0bf61fx6caecdd74b7dec50@mail.gmail.com>
<dcc563d10710100820p520698cctb65e5f5dc1a3a6e5@mail.gmail.com>
<20071010153201.65331672@joplin.trutwins.homeip.net>
On 10/10/07, Josh Trutwin <josh@trutwins.homeip.net> wrote:
> On Wed, 10 Oct 2007 10:20:02 -0500
> "Scott Marlowe" <scott.marlowe@gmail.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.
No, starting with 8.0, the code to manage the shared_buffers is much
more efficient with large numbers of shared buffers. With 8.0 and up
the primary considerations are that the shared_buffers be big enough
to hold your working set, but not so big as to run the system out of
memory for other things, sorts, kernel caching, etc...
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: scott.marlowe@gmail.com, josh@trutwins.homeip.net
Subject: Re: Shared Buffer setting in postgresql.conf
In-Reply-To: <dcc563d10710101358p55abb925pba894a693b21718f@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox