Skip site navigation (1) Skip section navigation (2)

Re: LISTEN/NOTIFY benchmarks?

From: prashanth(at)jibenetworks(dot)com
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: LISTEN/NOTIFY benchmarks?
Date: 2003-04-30 00:27:35
Message-ID: 20030430002735.GA4046@prashanth.jibenetworks.com (view raw or flat)
Thread:
Lists: pgsql-hackers
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


In response to

pgsql-hackers by date

Next:From: Sean ChittendenDate: 2003-04-30 00:30:46
Subject: Re: LISTEN/NOTIFY benchmarks?
Previous:From: Tom LaneDate: 2003-04-29 22:38:44
Subject: Re: "Adding missing from clause"

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group