From: Tom Lane <tgl@sss.pgh.pa.us>
To: Corey Horton <Corey_Horton@messageone.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: context switch storm in 8.1.4 on Xeon XP
Date: Mon, 12 May 2008 13:55:22 -0400
Message-ID: <23043.1210614922@sss.pgh.pa.us> (raw)
In-Reply-To: <C12DE7393B7AFA45BFD2A8BDC4BD440104AA7259@auscorpex-1.austin.messageone.com>
References: <C12DE7393B7AFA45BFD2A8BDC4BD440104AA7259@auscorpex-1.austin.messageone.com>
Corey Horton <Corey_Horton@messageone.com> writes:
> Running 8.1.4 on Xeon MP server running CenOS and we encountered what
> appears to be the context switch storm issue that I have seen described
> in 7.4 and perhaps is the same one mentioned here:
> http://www.postgresql.org/community/weeklynews/pwn20060903.html. Has
> this been addressed, and if so, in what version?
The patch mentioned there is in 8.2 and up. There are various other
patches that have gone in at different times to try to address other
contention issues. With so little data as this it's hard to tell
exactly what problem you hit. So, if you're going to consider a
major-version migration in hopes of solving a performance problem of
this kind, it'd likely be a good idea to go to 8.3.x instead of 8.2.x.
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-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, Corey_Horton@messageone.com
Subject: Re: context switch storm in 8.1.4 on Xeon XP
In-Reply-To: <23043.1210614922@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