Re: pgbouncer best practices

Поиск
Список
Период
Сортировка
От Ben Chobot
Тема Re: pgbouncer best practices
Дата
Msg-id f3d5bc21-205e-78ff-d952-7b980cd861b7@silentmedia.com
обсуждение исходный текст
Ответ на Re: pgbouncer best practices  (Rita <rmorgan466@gmail.com>)
Ответы Re: pgbouncer best practices  (Rita <rmorgan466@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Rita
Дата:
Сообщение: Re: pgbouncer best practices
Следующее
От: Lorusso Domenico
Дата:
Сообщение: How to add function schema in search_path in option definitio