Hacker News Reader

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