Re: Notify enhancement

Поиск
Список
Период
Сортировка
От Florian G. Pflug
Тема Re: Notify enhancement
Дата
Msg-id 45744F8A.1020200@phlo.org
обсуждение исходный текст
Ответ на Re: Notify enhancement  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Notify enhancement  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Tom Lane wrote:
> Andrew Dunstan <andrew@dunslane.net> writes:
>> How about Alvaro's suggestion of spilling to disk?
> 
> Won't that reintroduce most of the problems we're hoping to get rid of
> by removing the pg_listener table?  Certainly I'd not recommend putting
> that into the first iteration.

At least for my usecases, a blocking "notify" would be a serious 
problem. It basically means that one broken that stops calling
"listen ..." for whatever reason can cause all other clients to
stop..

With the current implementation, things just gradually slow down,
giving me time to react. So at least for me, blocking listen/notify
would be a regression...

Just my 0.02 eurocents, greetings
Florian Pflug


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

Предыдущее
От: "Timasmith"
Дата:
Сообщение: getting index columns from information_schema?
Следующее
От: Gregory Stark
Дата:
Сообщение: Re: Notify enhancement