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
>
>
>
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?) |