From: Scott Marlowe <smarlowe@g2switchworks.com>
To: Claus Guttesen <kometen@gmail.com>
Cc: Kenji Morishige <kenjim@juniper.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: Best OS & Configuration for Dual Xeon w/4GB &
Date: Fri, 17 Mar 2006 17:21:16 -0600
Message-ID: <1142637675.1141.38.camel@state.g2switchworks.com> (raw)
In-Reply-To: <b41c75520603171503s3e3ab20dq@mail.gmail.com>
References: <20060317221116.GA14661@juniper.net>
<b41c75520603171503s3e3ab20dq@mail.gmail.com>
On Fri, 2006-03-17 at 17:03, Claus Guttesen wrote:
> > Here is my current configuration:
> > Also, I may be overlooking a postgresql.conf setting. I have attached the
> > config file.
>
> You could try to lower shared_buffers from 30000 to 16384. Setting
> this value too high can in some cases be counterproductive according
> to doc's I read.
FYI, that was very true before 8.0, but since the introduction of better
cache management algorithms, you can have pretty big shared_buffers
settings.
> Also try to lower work_mem from 16384 to 8192 or 4096. This setting is
> for each sort, so it does become expensive in terms of memory when
> many sorts are being carried out. It does depend on the complexity of
> your sorts of course.
But looking at his usage of RAM on his box, it doesn't look like one at
the time that snapshot was taken. Assuming the box was busy then, he's
OK. Otherwise, he'd show a usage of swapping, which he doesn't.
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: smarlowe@g2switchworks.com, kometen@gmail.com, kenjim@juniper.net
Subject: Re: Best OS & Configuration for Dual Xeon w/4GB &
In-Reply-To: <1142637675.1141.38.camel@state.g2switchworks.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