Re: Some interesting results from tweaking spinlocks

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Some interesting results from tweaking spinlocks
Дата
Msg-id 9837.1010206146@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Some interesting results from tweaking spinlocks  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: Some interesting results from tweaking spinlocks
Список pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> The difference is small, perhaps 15%.

The thing that gets my attention is not that it's so small, it's that
it is so large.  My expectation was that that code would hardly ever
be executed at all, and even less seldom (on a multiprocessor) need to
block via select().  How is it that *increasing* the delay interval
(which one might reasonably expect to simply waste cycles) can achieve
a 15% improvement in total throughput?  That shouldn't be happening.

> My feeling is that we may want to start configuring whether we are on
> a multi-cpu machine and handle thing differently.

That would be more palatable if there were some portable way of
detecting it.  But maybe we'll be forced into an "is_smp" GUC switch.
        regards, tom lane


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Some interesting results from tweaking spinlocks
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Some interesting results from tweaking spinlocks