Re: Seeing context switch storm with 10/13 snapshot of

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Seeing context switch storm with 10/13 snapshot of
Дата
Msg-id 25797.1129929473@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Seeing context switch storm with 10/13 snapshot of  (Simon Riggs <simon@2ndquadrant.com>)
Ответы Re: Seeing context switch storm with 10/13 snapshot of  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: Seeing context switch storm with 10/13 snapshot of  (Simon Riggs <simon@2ndquadrant.com>)
Список pgsql-hackers
Simon Riggs <simon@2ndquadrant.com> writes:
> Certainly there is a lack of ideas as to how to fix it, as you mention
> in (3). This shows to me that the solution lies in one of two areas: a)
> the solution has not yet been considered or b) the solution has already
> been thought of and for whatever reason disregarded. You may be certain
> that the solution lies in a), though I am not. Rejecting ideas quickly
> may simply increase the chances of finding the solution in a b) case.

However, building a spinlock test harness presupposes that the solution
lies in the spinlock code itself, and not in (say) changing our usage
patterns of it.  So I'd throw the "rejecting ideas too quickly"
challenge right back at you.  What we need to optimize is the behavior
in the real context of Postgres, not in a test harness.
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [PATCHES] Win32 CHECK_FOR_INTERRUPTS() performance tweak
Следующее
От: Neil Conway
Дата:
Сообщение: Re: [COMMITTERS] pgsql: Do all accesses to shared buffer