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.
In response to
pgsql-hackers by date
|Next:||From: Sean Chittenden||Date: 2003-04-30 00:30:46|
|Subject: Re: LISTEN/NOTIFY benchmarks?|
|Previous:||From: Tom Lane||Date: 2003-04-29 22:38:44|
|Subject: Re: "Adding missing from clause" |