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

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Mysterious connections to PostgreSQL (no statement) coming from pgbouncer (mode = transaction)
Дата
Msg-id CAKFQuwa2pM4FTXpomL_tkeFmHkB+1xk2OO9j=2AtQ5xcy7fMow@mail.gmail.com
обсуждение исходный текст
Ответ на Mysterious connections to PostgreSQL (no statement) coming from pgbouncer (mode = transaction)  (Achilleas Mantzios <a.mantzios@cloud.gatewaynet.com>)
Ответы Re: Mysterious connections to PostgreSQL (no statement) coming from pgbouncer (mode = transaction)
Список pgsql-admin
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.

David J.

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