Re: Connections - Postgres 9.2

Поиск
Список
Период
Сортировка
От Charles Clavadetscher
Тема Re: Connections - Postgres 9.2
Дата
Msg-id A956FE23-E541-4E5D-BE91-3842DA6E41F6@swisspug.org
обсуждение исходный текст
Ответ на Re: Connections - Postgres 9.2  (Francisco Olarte <folarte@peoplecall.com>)
Ответы Re: Connections - Postgres 9.2  (Francisco Olarte <folarte@peoplecall.com>)
Re: Connections - Postgres 9.2  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
Hello

On 16.05.2016, at 18:32, Francisco Olarte <folarte@peoplecall.com> wrote:

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 ).


There really is a state 'Idle in transaction'? Good to learn.
Thank you and bye
Charles

Francisco Olarte.

 

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

Предыдущее
От: Francisco Olarte
Дата:
Сообщение: Re: Connections - Postgres 9.2
Следующее
От: Francisco Olarte
Дата:
Сообщение: Re: Connections - Postgres 9.2