Re: pgbouncer best practices

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(at)silentmedia(dot)com> 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.--