Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

> 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.)




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: