On Sun, Jul 9, 2023 at 6:28 AM Rita wrote:
>
> Is there a way to see how many queued connections there are? Looking at the
> stats I can't seem to figure that out.
pgbouncer exposes quite a few statistics via the SHOW commands [1].
See if any of those help.
[1]: https://www.pgbouncer.org/usage.
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 wrote:
> Ri
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
I am not sure if it allows transaction pooling.
On Fri, Jul 7, 2023 at 12:37 PM Ben Chobot 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.
On Fri, Jul 7, 2023 at 9:24 AM Rita wrote:
>
> My question are: is there a ratio of max connections and pool i should use in
> my pgbouncer config?
Short answer: No, there's no recommended ratio for PG max_connections
and pgbouncer pool size.
In pgbouncer, a client connection is matched (forwar
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 fa
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
pgbou
