Chris Browne <cbbrowne@xxxxxxx> writes: > tgl@xxxxxxxxxxxxx (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 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org