zlacker

[return to "Choose Postgres queue technology"]
1. dikei+fB[view] [source] 2023-09-25 02:44:40
>>bo0tzz+(OP)
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.
◧◩
2. rockwo+nB[view] [source] 2023-09-25 02:45:42
>>dikei+fB
I used a separate dedicated connection for listen that wasn’t in the pool. Notify is fine to be apart of a normal txn
[go to top]