Re: proposal: make NOTIFY list de-duplication optional - Mailing list pgsql-hackers

From Merlin Moncure
Subject Re: proposal: make NOTIFY list de-duplication optional
Date
Msg-id CAHyXU0zf-nFfpkHHw7Lme-OPJJ5j4sNs2kSCK9=YUURUB8zU5Q@mail.gmail.com
Whole thread Raw
In response to Re: proposal: make NOTIFY list de-duplication optional  (Filip Rembiałkowski <filip.rembialkowski@gmail.com>)
Responses Re: proposal: make NOTIFY list de-duplication optional
List pgsql-hackers
On Mon, Feb 8, 2016 at 2:33 PM, Filip Rembiałkowski
<filip.rembialkowski@gmail.com> wrote:
> Here is my next try, after suggestions from -perf and -hackers list:
>
> * no GUC
>
> * small addition to NOTIFY grammar: NOTIFY ALL/DISTINCT
>
> * corresponding, 3-argument version of pg_notify(text,text,bool)

This is all sounding pretty good.   I wonder if the third argument
should be a boolean however.  If we make it 'text, 'send mode',
instead, we could leave some room for more specialization of the
queuing behavior.

For example, we've had a couple of requests over the years to have an
'immediate' mode which dumps the notification immediately to the
client without waiting for tx commit. This may or may not be a good
idea, but if it was ultimately proved to be, it could be introduced as
an alternate mode without adding an extra function.

merlin



pgsql-hackers by date:

Previous
From: Corey Huinker
Date:
Subject: Re: enable parallel query by default?
Next
From: Robert Haas
Date:
Subject: Re: a raft of parallelism-related bug fixes