Re: pgbouncer best practices

I am not sure if it allows transaction pooling.

On Fri, Jul 7, 2023 at 12:37 PM Ben Chobot <bench(at)silentmedia(dot)com> wrote:

> Rita wrote on 7/7/23 9:23 AM:
>
> I have an application that does many db calls from a server farm. I've
> increased my max connections on postgresql to 1000 and tuned the server
> accordingly. However, I still get can't connect to postgresql some times. I
> installed pgbouncer on few servers in the farm. I pointed the traffic to
> pgbouncer and things helped dramatically. My question are: is there a ratio
> of max connections and pool i should use in my pgbouncer config?
>
>
> Does your application allow for transaction pooling? pgBouncer can unlock
> a lot more efficiency if you can cycle server slots on transaction
> boundaries.
>

--
--- Get your facts first, then you can distort them as you please.--