Re: Mysterious connections to PostgreSQL (no statement) coming from pgbouncer (mode = transaction)

Поиск
Список
Период
Сортировка
От Achilleas Mantzios
Тема Re: Mysterious connections to PostgreSQL (no statement) coming from pgbouncer (mode = transaction)
Дата
Msg-id ee523c17-463d-4034-abcb-091924272720@cloud.gatewaynet.com
обсуждение исходный текст
Ответ на Re: Mysterious connections to PostgreSQL (no statement) coming from pgbouncer (mode = transaction)  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-admin
Дерево обсуждения


Στις 18/11/24 22:07, ο/η David G. Johnston έγραψε:
On Mon, Nov 18, 2024 at 1:03 PM Achilleas Mantzios <a.mantzios@cloud.gatewaynet.com> wrote:

We have been running pgbouncer (since 1.8) for quite some years, and today I realized I have connections to the DB from pgbouncer that don't do anything, do not execute any statement.


Seems reasonable that a pooler would open connections to PostgreSQL to prime the pool even before any demand is seen.  That way demand is immediately given a functioning connection.

Hello David,

I forgot to mention that in pgbouncer : min_pool_size=0 . So not reasonable.


David J.

В списке pgsql-admin по дате отправления: