Re: [GENERAL] postgres: dbname dbuser 9.9.9.9[2222] PARSE waiting

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: [GENERAL] postgres: dbname dbuser 9.9.9.9[2222] PARSE waiting
Дата
Msg-id CAKFQuwZbZ10RuCNoJpvt7g2vAi9RLcpeodcmrUeXrCXe+Q+f9g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] postgres: dbname dbuser 9.9.9.9[2222] PARSE waiting  (Melvin Davidson <melvin6925@gmail.com>)
Список pgsql-general
Дерево обсуждения
On Tue, Jun 27, 2017 at 3:41 PM, Melvin Davidson <melvin6925@gmail.com> wrote:
His problem is NOT 'idle in transaction' per se. It is all connections are used up.
Hence the need for pg_bouncer for connection pooling.


Whether pg_bouncer provides a viable solution is just as big an unknown as whether "idle in transaction" is the biggest contributor to the problem.  If all of them are idle in transaction then pg_bouncer is powerless to help.  If they are generally just long-lived sessions and only a few stay in transaction then transaction pooling mode may help.

David J.

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: [GENERAL] postgres: dbname dbuser 9.9.9.9[2222] PARSE waiting
Следующее
От: DrakoRod
Дата:
Сообщение: Re: [GENERAL] postgres: dbname dbuser 9.9.9.9[2222] PARSE waiting