Re: Feature request: NOTIFY enhancement - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Feature request: NOTIFY enhancement
Date
Msg-id 20080103180629.GG10950@alvh.no-ip.org
Whole thread Raw
In response to Re: Feature request: NOTIFY enhancement  (Andreas 'ads' Scherbaum <adsmail@wars-nicht.de>)
Responses Re: Feature request: NOTIFY enhancement  (Bruce Momjian <bruce@momjian.us>)
List pgsql-general
Andreas 'ads' Scherbaum wrote:

> It is possible, that some notifies, if following in a very short time
> frame, can get lost.
>
> In case we want to send extra text messages with NOTIFY, we should make
> sure, that no notify get lost.

Right.  Currently, NOTIFY acts like Unix signals -- consecutive signals
can get "collapsed" into a single one, and the listening process is
responsible for ensuring that it gets the communication details from
elsewhere.

If the idea is to convert NOTIFY into a full-blown communication system,
then no collapsing can take place.  This means the additional data
(which can be of unbounded size) must be stored elsewhere, probably on
disk.

So far (AFAIK), the only detailed design proposal came from Neil Conway,
which used SLRU for storage, but AFAIK he didn't take it much further.

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

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Feature request: NOTIFY enhancement
Next
From: Bruce Momjian
Date:
Subject: Re: Feature request: NOTIFY enhancement