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]