Re: pgbouncer best practices - Mailing list pgsql-general

From Ben Chobot
Subject Re: pgbouncer best practices
Date
Msg-id f3d5bc21-205e-78ff-d952-7b980cd861b7@silentmedia.com
Whole thread Raw
In response to Re: pgbouncer best practices  (Rita <rmorgan466@gmail.com>)
Responses Re: pgbouncer best practices  (Rita <rmorgan466@gmail.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Rita
Date:
Subject: Re: pgbouncer best practices
Next
From: Lorusso Domenico
Date:
Subject: How to add function schema in search_path in option definitio