Re: Notify enhancement

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Notify enhancement
Дата
Msg-id 20061204143311.GC28324@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: Notify enhancement  (Andrew Dunstan <andrew@dunslane.net>)
Ответы Re: Notify enhancement  (Andrew Dunstan <andrew@dunslane.net>)
Список pgsql-hackers
Andrew Dunstan wrote:

> Ok. But I think the buffer size as a whole needs to be fixed, no? And if 
> so, we probably need some limit on message size to prevent "NOTIFY 
> some_event 'a really long string'; " from filling up the buffer in one hit.
> 
> I'm also trying to figure out what a reasonable default buffer size will 
> be. Thinking of the needs for which I will be providing (one listener, 
> small names/payloads), 256Kb or 512Kb would be ample, possibly even 
> excessive. But other users might have bigger needs.

Make it configurable via GUC.

What will happen when the ring is full?  NOTIFY blocks?

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


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

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: Notify enhancement
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: Notify enhancement