Re: notification payloads

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: notification payloads
Дата
Msg-id 11551.1174969293@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: notification payloads  (Andrew Dunstan <andrew@dunslane.net>)
Ответы Re: notification payloads  (Andrew Dunstan <andrew@dunslane.net>)
Список pgsql-hackers
Andrew Dunstan <andrew@dunslane.net> writes:
> ... But ISTM that means we just need to pick a few strategic spots 
> that will call CHECK_FOR_NOTIFICATIONS() even in the middle of a 
> transaction and store them locally.

Minor comment --- I don't believe in having a separate "sprinkle" of
notify-specific checks.  It needs to be set up so that
CHECK_FOR_INTERRUPTS will deal with the catch-up-please signal.  We've
already done (most of) the work of making sure CHECK_FOR_INTERRUPTS is
called often enough, and AFAICS we'd end up needing
CHECK_FOR_NOTIFICATIONS in exactly those same loops anyway.

It definitely helps here that CHECK_FOR_NOTIFICATIONS need affect only
localized state of a particular subsystem that nothing else depends on.
I've been wishing we could handle SI inval at more places than we do
now, but that seems a lot harder :-(
        regards, tom lane


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

Предыдущее
От: "Greg Sabino Mullane"
Дата:
Сообщение: Re: [BUGS] "Relation not found" error but table exits.
Следующее
От: Hannu Krosing
Дата:
Сообщение: Re: notification payloads