Re: Connections - Postgres 9.2

Поиск
Список
Период
Сортировка
От Francisco Olarte
Тема Re: Connections - Postgres 9.2
Дата
Msg-id CA+bJJbzmb_atz5mTn2X3XnhWTLc0g0swgDOG6htbiDmyWLz9ng@mail.gmail.com
обсуждение исходный текст
Ответ на Connections - Postgres 9.2  (Lucas Possamai <drum.lucas@gmail.com>)
Ответы Re: Connections - Postgres 9.2  (Charles Clavadetscher <clavadetscher@swisspug.org>)
Список pgsql-general
Hi Lucas

On Mon, May 16, 2016 at 4:10 AM, Lucas Possamai <drum.lucas@gmail.com> wrote:

Those IDLE connections, might be because the user/application didn't commit the transaction?

​IIRC Those would be 'Idle in transaction' ( which are normally bad if numerous, unless your app has a reason for them, as they are the ones which can block things ). Plain 'Idle' are normally connections between transactions, totally normal if you use poolers, or if your app keeps connection opens while it does other things ( like preparing for a transaction ).

Francisco Olarte.

 

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

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: Toolchain for extensions (language C, Visual Studio 2013 / 2015)
Следующее
От: Charles Clavadetscher
Дата:
Сообщение: Re: Connections - Postgres 9.2