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

From Tom Lane
Subject Re: LISTEN/NOTIFY benchmarks?
Date
Msg-id 11548.1051582756@sss.pgh.pa.us
Whole thread Raw
In response to LISTEN/NOTIFY benchmarks?  (prashanth@jibenetworks.com)
Responses Re: LISTEN/NOTIFY benchmarks?  (prashanth@jibenetworks.com)
List pgsql-hackers
prashanth@jibenetworks.com writes:
> I'm not an expert on signals, not even a novice, so I might be totally
> off base, but it seems like the Async Notification implementation does
> not scale.

Very possibly.  You didn't even mention the problems that would occur if
the pg_listener table didn't get vacuumed often enough.

The pghackers archives contain some discussion about reimplementing
listen/notify using a non-table-based infrastructure.  But AFAIK no one
has picked up that task yet.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: How about an am_superuser GUC parameter (non-settable)?
Next
From: Bruce Momjian
Date:
Subject: Re: How about an am_superuser GUC parameter (non-settable)?