Re: sinval.c / sinvaladt.c restructuring

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: sinval.c / sinvaladt.c restructuring
Дата
Msg-id 9134.1205714027@sss.pgh.pa.us
обсуждение исходный текст
Ответ на sinval.c / sinvaladt.c restructuring  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-patches
Alvaro Herrera <alvherre@commandprompt.com> writes:
> One side effect of this change is that the call to SendPostmasterSignal
> now occurs after the lock has been released.  ISTM this is a good idea
> on general principles (no syscalls in lwlocked code), but I'm wondering
> if I created a thundering hoard problem that did not exist before.

Forgot to reply to this earlier, but I think this is OK.  The test for
setting signal_postmaster is for exact equality of numMsgs to a
threshold, so at least in simple cases only one backend will send the
signal.  You could imagine scenarios where the slowest backend is trying
to catch up and numMsgs oscillates around the threshold, but it seems
unlikely to be a problem in practice.  I concur that moving the signal
out of the locked code is a good thing.  (Maybe move the elog(DEBUG4)
as well?)

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Hash Index Build Patch v2
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [PERFORM] Very slow (2 tuples/second) sequential scan after bulk insert; speed returns to ~500 tuples/second after commit