Re: spinlock->pthread_mutex : first results with Jeff's pgbench+plsql

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: spinlock->pthread_mutex : first results with Jeff's pgbench+plsql
Дата
Msg-id 19536.1341249235@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: spinlock->pthread_mutex : first results with Jeff's pgbench+plsql  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> The delay code is stupider than it could be, in that it sleeps without
> regard to what's happening elsewhere in the system.  The futex stuff
> was interesting to me because it potentially provides a way to sleep
> "until something interesting happens" rather than "for a fixed amount
> of time".  But it's unclear to me what exactly we'd have to do to
> squeeze out a win, or even whether it's possible.

Right.  AFAICS, sleeping "until something happens" necessarily requires
adding overhead on the other side, ie, lock releasers will have to do
something extra to wake up sleepers.  If that means adding overhead
to low-contention cases, we could come out behind even if it improves
high-contention cases.  Tradeoffs, always tradeoffs ...
        regards, tom lane


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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Checkpointer on hot standby runs without looking checkpoint_segments
Следующее
От: Nils Goroll
Дата:
Сообщение: away soon - spinlock->pthread_mutex : first results with Jeff's pgbench+plsql