pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
context switch storm in 8.1.4 on Xeon XP
2+ messages / 2 participants
[nested] [flat]

* context switch storm in 8.1.4 on Xeon XP
@ 2008-05-12 16:58 Corey Horton <Corey_Horton@messageone.com>
  2008-05-12 17:55 ` Re: context switch storm in 8.1.4 on Xeon XP Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 2+ messages in thread

From: Corey Horton @ 2008-05-12 16:58 UTC (permalink / raw)
  To: pgsql-admin

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?  I apologize if this
was in the release notes somewhere and I missed it.  I'll be happy to
provide more details if necessary, though we restarted server before I
had chance to gather much information.  If this needs further
investigation, what type of information would be useful to debug this
problem should it appear again?

 

Thanks,

Corey Horton

 

 

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: context switch storm in 8.1.4 on Xeon XP
  2008-05-12 16:58 context switch storm in 8.1.4 on Xeon XP Corey Horton <Corey_Horton@messageone.com>
@ 2008-05-12 17:55 ` Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2008-05-12 17:55 UTC (permalink / raw)
  To: Corey Horton <Corey_Horton@messageone.com>; +Cc: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2008-05-12 17:55 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-05-12 16:58 context switch storm in 8.1.4 on Xeon XP Corey Horton <Corey_Horton@messageone.com>
2008-05-12 17:55 ` Tom Lane <tgl@sss.pgh.pa.us>

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