Re: LISTEN/NOTIFY benchmarks? - Mailing list pgsql-hackers

From prashanth@jibenetworks.com
Subject Re: LISTEN/NOTIFY benchmarks?
Date
Msg-id 20030430002735.GA4046@prashanth.jibenetworks.com
Whole thread Raw
In response to Re: LISTEN/NOTIFY benchmarks?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Tue, Apr 29, 2003 at 06:21:15PM -0400, Tom Lane wrote:
> prashanth@jibenetworks.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



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: "Adding missing from clause"
Next
From: Sean Chittenden
Date:
Subject: Re: LISTEN/NOTIFY benchmarks?