Re: pgbouncer best practices - Mailing list pgsql-general

From Rita
Subject Re: pgbouncer best practices
Date
Msg-id CAOF-KfjaXr-nzruThPjRyiie9Zs46pEy_gRTFEHuV3ynWz_mEw@mail.gmail.com
Whole thread Raw
In response to Re: pgbouncer best practices  (Ben Chobot <bench@silentmedia.com>)
Responses Re: pgbouncer best practices  (Gurjeet Singh <gurjeet@singh.im>)
List pgsql-general
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@silentmedia.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.--

pgsql-general by date:

Previous
From: jian he
Date:
Subject: now() literal in pg_input_is_valid
Next
From: Tom Lane
Date:
Subject: Re: now() literal in pg_input_is_valid