Thanks for the tips. So far, I am very happy with PGbouncer. Just increased number of db connections. Great piece of software!
Is there a way to see how many queued connections there are? Looking at the stats I can't seem to figure that out.
On Sat, Jul 8, 2023 at 9:46 AM Ben Chobot <bench@xxxxxxxxxxxxxxx> wrote:
Rita wrote on 7/8/23 4:27 AM:I am not sure if it allows transaction pooling.
Well, take the time to figure it out. With transaction pooling enabled, you can get away with a much lower number of server connections. For example, our application regularly has thousands of clients connected to pgbouncer and is quite happy with ~30 server connections (roughly the core count of the db server). If we couldn't use transaction pooling we'd be fighting with how to keep those thousands of connections from wasting a bunch of resources on our db.
https://www.pgbouncer.org/features.html
--- Get your facts first, then you can distort them as you please.--
