Re: Notify enhancement - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Notify enhancement
Date
Msg-id 20061204143311.GC28324@alvh.no-ip.org
Whole thread Raw
In response to Re: Notify enhancement  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: Notify enhancement  (Andrew Dunstan <andrew@dunslane.net>)
List 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 by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: Notify enhancement
Next
From: Andrew Dunstan
Date:
Subject: Re: Notify enhancement