Chris Browne <cbbrowne(at)acm(dot)org> writes:
> tgl(at)sss(dot)pgh(dot)pa(dot)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