4 ms·
> Anyone know how connection pooling works with listeners? They don't. LISTEN is per connection and pgbouncer multiplexes many sessions onto a single one. The
by mulander 7y ago
> Anyone know how connection pooling works with listeners?
They don't. LISTEN is per connection and pgbouncer multiplexes many sessions onto a single one. The poller holds the connection and has no way to propagate back the notification while still maintaining multiplexed sessions as isolated.
- directionless 7y agoWell there we go. So while postgres makes for a pretty awesome database, and a pretty good queueing system, some folks may be seriously impacted by the max number of connections