Re: Toooo many context switches (maybe SLES8?)
Dirk Lutzebaeck <dirk.lutzebaeck@t-online.de>
From: Dirk.Lutzebaeck@t-online.de (Dirk Lutzebaeck)
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Joe Conway <mail@joeconway.com>, pgsql-performance@postgresql.org
Date: 2004-04-15T20:03:39Z
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@joeconway.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 > > >