Rita wrote on 7/8/23 4:27 AM:
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 |
