From: Merlin Moncure <mmoncure@gmail.com>
To: Cosimo Streppone <cosimo@streppone.it>
Cc: Richard Huxton <dev@archonet.com>
Cc: Postgresql Performance list <pgsql-performance@postgresql.org>
Subject: Re: Context switch storm
Date: Tue, 14 Nov 2006 09:17:08 -0500
Message-ID: <b42b73150611140617m446e801bj7ec834bc661c138a@mail.gmail.com> (raw)
In-Reply-To: <455991B0.6070209@streppone.it>
References: <efc1d7c07cf.454afe8d@brturbo.com.br>
<454B3B75.6@archonet.com>
<454B3EDC.3090502@streppone.it>
<454B4438.9080105@archonet.com>
<455991B0.6070209@streppone.it>
On 11/14/06, Cosimo Streppone <cosimo@streppone.it> wrote:
> I must say I lowered "shared_buffers" to 8192, as it was before.
> I tried raising it to 16384, but I can't seem to find a relationship
> between shared_buffers and performance level for this server.
My findings are pretty much the same here. I don't see any link
between shared buffers and performance. I'm still looking for hard
evidence to rebut this point. Lower shared buffers leaves more
memory for what really matters, which is sorting.
> > Well, the client I saw it with just bought a dual-opteron server and
> > used their quad-Xeon for something else. However, I do remember that 8.1
> > seemed better than 7.4 before they switched. Part of that might just
> > have been better query-planning and other efficiences though.
>
> An upgrade to 8.1 is definitely the way to go.
> Any 8.0 - 8.1 migration advice?
If you are getting ready to stage an upgrade, you definately will want
to test on 8.2 and 8.1. 8.2 might give you better results in the lab,
and has some nice features.
merlin
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: mmoncure@gmail.com, cosimo@streppone.it, dev@archonet.com
Subject: Re: Context switch storm
In-Reply-To: <b42b73150611140617m446e801bj7ec834bc661c138a@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