Re: Notify enhancement

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