Comment by ulrikrasmussen
1 year ago
> LISTEN/NOTIFY doesn't work through connection pooling
What's the problem with using it with connection pooling?
1 year ago
> LISTEN/NOTIFY doesn't work through connection pooling
What's the problem with using it with connection pooling?
Best to just forget about it and listen on a connection not using pooling.
https://jpcamara.com/2023/04/12/pgbouncer-is-useful.html#lis...
asyncpg clears out any listeners you have setup once a connection is returned to pool. This will lead to 'missed' events. I guess its something of the same story with psycopg?
If event(s) any jobs will be picked up by the next event or by a timer that checks every 30 seconds or so (can be set by the dev.)