On Tue, Apr 29, 2003 at 06:21:15PM -0400, Tom Lane wrote:
> prashanth(at)jibenetworks(dot)com writes:
> > If the listening backend had registered tens of thousands of LISTENs,
> > it would be sent an equivalent number of signals during a single run
> > of AtCommit_Notify().
>
> Not unless the notifier had notified all tens of thousands of condition
> names in a single transaction.
Unfortunately, that is a possibility in our application. We are now
working around this non-scalability.
Regardless, it would seem redundant to send more than one SIG_USR2 to the
recipient backend in that loop.
-- prashanth