Comment by dikei
3 years ago
IIRC, LISTEN/NOTIFY needs to pin a PostgreSQL connection to the client, so you won't be able to use transaction-level pooling with it.
3 years ago
IIRC, LISTEN/NOTIFY needs to pin a PostgreSQL connection to the client, so you won't be able to use transaction-level pooling with it.
I used a separate dedicated connection for listen that wasn’t in the pool. Notify is fine to be apart of a normal txn