From: Tom Lane <tgl@sss.pgh.pa.us>
To: Vivek Khera <vivek@khera.org>
Cc: Postgresql Performance <pgsql-performance@postgresql.org>
Cc: Anjan Dave <adave@vantage.com>
Subject: Re: High context switches occurring
Date: Tue, 22 Nov 2005 12:35:49 -0500
Message-ID: <12638.1132680949@sss.pgh.pa.us> (raw)
In-Reply-To: <0D46FCC7-9DB2-4B45-B7C3-4F76EF53DB1F@khera.org>
References: <4BAFBB6B9CC46F41B2AD7D9F4BBAF785098E73@vt-pe2550-001.vantage.vantage.com>
<0D46FCC7-9DB2-4B45-B7C3-4F76EF53DB1F@khera.org>
Vivek Khera <vivek@khera.org> writes:
> On Nov 22, 2005, at 11:59 AM, Anjan Dave wrote:
>> This is a Dell Quad XEON. Hyperthreading is turned on, and I am
>> planning to turn it off as soon as I get a chance to bring it down.
> You should probably also upgrade to Pg 8.0 or newer since it is a
> known problem with XEON processors and older postgres versions.
> Upgrading Pg may solve your problem or it may not.
PG 8.1 is the first release that has a reasonable probability of
avoiding heavy contention for the buffer manager lock when there
are multiple CPUs. If you're going to update to try to fix this,
you need to go straight to 8.1.
I've recently been chasing a report from Rob Creager that seems to
indicate contention on SubTransControlLock, so the slru code is
likely to be our next bottleneck to fix :-(
regards, tom lane
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: tgl@sss.pgh.pa.us, vivek@khera.org, adave@vantage.com
Subject: Re: High context switches occurring
In-Reply-To: <12638.1132680949@sss.pgh.pa.us>
* 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