Re: Toooo many context switches (maybe SLES8?)

From: Dirk(dot)Lutzebaeck(at)t-online(dot)de (Dirk Lutzebaeck)
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Joe Conway <mail(at)joeconway(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Toooo many context switches (maybe SLES8?)
Date: 2004-04-15 20:03:39
Message-ID: 407EEA9B.7010807@aeccom.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Could this be related to the O(1) scheduler backpatches from 2.6 to 2.4
kernel on newer 2.4er distros (RedHat, SuSE)?

Tom Lane wrote:

>Joe Conway <mail(at)joeconway(dot)com> writes:
>
>
>>>Improve spinlock code for recent x86 processors: insert a PAUSE
>>>instruction in the s_lock() wait loop, and use test before test-and-set
>>>in TAS() macro to avoid unnecessary bus traffic. Patch from Manfred
>>>Spraul, reworked a bit by Tom.
>>>
>>>
>
>
>
>>I thought this had been committed to the 7.4 stable branch as well, but
>>it appears not.
>>
>>
>
>I am currently chasing what seems to be the same issue: massive context
>swapping on a dual Xeon system. I tried back-patching the above-mentioned
>patch ... it helps a little but by no means solves the problem ...
>
> regards, tom lane
>
>
>

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Bill Moran 2004-04-15 20:13:30 Re: [ SOLVED ] select count(*) very slow on an already
Previous Message Tom Lane 2004-04-15 19:37:21 Re: Toooo many context switches (maybe SLES8?)