From: Greg Smith <gsmith@gregsmith.com>
To: Matthew Lunnon <mlunnon@rwa-net.co.uk>
Cc: pgsql-performance@postgresql.org
Subject: Re: Limited performance on multi core server
Date: Wed, 12 Dec 2007 06:48:48 -0500 (EST)
Message-ID: <Pine.GSO.4.64.0712120637240.15530@westnet.com> (raw)
In-Reply-To: <475FB50B.8060701@rwa-net.co.uk>
References: <475FB50B.8060701@rwa-net.co.uk>
On Wed, 12 Dec 2007, Matthew Lunnon wrote:
> I have a 4 * dual core 64bit AMD OPTERON server with 16G of RAM, running
> postgres 7.4.3.
> shared_buffers = 96000
As you've already been told repeatedly 7.4 is a release from long before
optimizations to work well on a multi-core server like this. I'll only
add that because of those problems, larger values of shared_buffers were
sometimes counter-productive with these old versions. You should try
reducing that to the 10,000-50000 range and see if things improve; that's
the general range that was effective with 7.4. Continue to set
effective_cache_size to a large value so that the optimizer knows how much
RAM is really available.
--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD
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: gsmith@gregsmith.com, mlunnon@rwa-net.co.uk
Subject: Re: Limited performance on multi core server
In-Reply-To: <Pine.GSO.4.64.0712120637240.15530@westnet.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