Re: Is LISTEN/NOTIFY reliable?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Tatsuo Ishii <ishii(at)postgresql(dot)org>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Is LISTEN/NOTIFY reliable?
Date: 2010-10-16 13:48:07
Message-ID: 6074.1287236887@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tatsuo Ishii <ishii(at)postgresql(dot)org> writes:
> Does anybody know PostgreSQL LISTEN/NOTIFY is more reliable than
> previous versions? I vaguely recall that in the previous
> implementation, message sent by NOTIFY may not be reached to listner.
> Does PostgreSQL 9.0's new implementation guarantee that the message is
> received by the listener?

No more or less than the old one did.

The old design intentionally dropped duplicate notifications, and the
new one does too (though with a narrower definition of "duplicate").
Modulo that well-documented behavior, I know of no reason to describe
either the old or new code as unreliable.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2010-10-16 13:59:20 Re: Extensions, this time with a patch
Previous Message Robert Haas 2010-10-16 13:04:57 Re: Is LISTEN/NOTIFY reliable?