Re: Toooo many context switches (maybe SLES8?)

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Toooo many context switches (maybe SLES8?)
Дата
Msg-id 20498.1082057841@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Toooo many context switches (maybe SLES8?)  (Joe Conway <mail@joeconway.com>)
Ответы Re: Toooo many context switches (maybe SLES8?)  (Josh Berkus <josh@agliodbs.com>)
Re: Toooo many context switches (maybe SLES8?)  (Dirk.Lutzebaeck@t-online.de (Dirk Lutzebaeck))
Список pgsql-performance
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

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Simon Riggs"
Дата:
Сообщение: Re: PostgreSQL and Linux 2.6 kernel.
Следующее
От: Bill Moran
Дата:
Сообщение: Re: [ SOLVED ] select count(*) very slow on an already