Re: pgbouncer best practices - Mailing list pgsql-general

From Rita
Subject Re: pgbouncer best practices
Date
Msg-id CAOF-Kfiwx0AfH8Kvwj4uqTP3USW4hNSOGM1eAJtYia9otmxu-Q@mail.gmail.com
Whole thread Raw
In response to Re: pgbouncer best practices  (Ben Chobot <bench@silentmedia.com>)
Responses Re: pgbouncer best practices
List pgsql-general
I am not sure if it allows transaction pooling. 

On Fri, Jul 7, 2023 at 12:37 PM Ben Chobot <bench@silentmedia.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.--

pgsql-general by date:

Previous
From: Gurjeet Singh
Date:
Subject: Re: pgbouncer best practices
Next
From: Ben Chobot
Date:
Subject: Re: pgbouncer best practices