Re: Anyone interested in improving postgresql scaling?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Anyone interested in improving postgresql scaling?
Дата
Msg-id 28537.1176230816@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Anyone interested in improving postgresql scaling?  (Mark Kirkwood <markir@paradise.net.nz>)
Ответы Re: Anyone interested in improving postgresql scaling?  (Kris Kennaway <kris@obsecurity.org>)
Список pgsql-hackers
Kris Kennaway <kris@obsecurity.org> writes:
>>> Make SYSV semaphores less dumb about process wakeups.  Currently
>>> whenever the semaphore state changes, all processes sleeping on the
>>> semaphore are woken, even if we only have released enough resources
>>> for one waiting process to claim.

>> Correct.  The behavior Kris describes is surely bad, but it's not
>> relevant to Postgres' usage of SysV semaphores.

> Sorry, but the behaviour is real.

Oh, I'm sure the BSD kernel acts as you describe.  But Mark's point is
that Postgres never has more than one process waiting on any particular
SysV semaphore, and so the problem doesn't really affect us.

Or do you mean that the kernel wakes all processes sleeping on *any*
SysV semaphore?  That would be nasty :-(
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [PATCHES] Fix mdsync never-ending loop problem
Следующее
От: "Gurjeet Singh"
Дата:
Сообщение: Re: [PATCHES] [Fwd: Index Advisor]