Re: About dropped notifications - Mailing list pgsql-general

From Tom Lane
Subject Re: About dropped notifications
Date
Msg-id 14948.1125358749@sss.pgh.pa.us
Whole thread Raw
In response to Re: About dropped notifications  (Chris Browne <cbbrowne@acm.org>)
List pgsql-general
Chris Browne <cbbrowne@acm.org> writes:
> tgl@sss.pgh.pa.us (Tom Lane) writes:
>> with the current implementation, a transaction will emit only
>> one notify per notify event name, even if NOTIFY is executed
>> many times within the transaction.

> An interesting question is whether or not the relevant tuple in
> pg_listener gets invalidated once, or whether doing 2500 attempted
> NOTIFY requests blows through 2500 copies.

Once.  (Per transaction...)

            regards, tom lane

pgsql-general by date:

Previous
From: vishal saberwal
Date:
Subject: Re: PQConnectdb SSL (sslmode): Is this a bug
Next
From: Tom Lane
Date:
Subject: Re: About "ERROR: must be *superuser* to COPY to or from a file"