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)
Список
Дерево обсуждения
Connections - Postgres 9.2 Lucas Possamai <drum.lucas@gmail.com>
Re: Connections - Postgres 9.2 Charles Clavadetscher <clavadetscher@swisspug.org>
Re: Connections - Postgres 9.2 Francisco Olarte <folarte@peoplecall.com>
Re: Connections - Postgres 9.2 Charles Clavadetscher <clavadetscher@swisspug.org>
Re: Connections - Postgres 9.2 Adrian Klaver <adrian.klaver@aklaver.com>
Re: Connections - Postgres 9.2 Lucas Possamai <drum.lucas@gmail.com>
Re: Connections - Postgres 9.2 Adrian Klaver <adrian.klaver@aklaver.com>
Re: Connections - Postgres 9.2 John R Pierce <pierce@hogranch.com>
Re: Connections - Postgres 9.2 Adrian Klaver <adrian.klaver@aklaver.com>
Re: Connections - Postgres 9.2 John R Pierce <pierce@hogranch.com>
Re: Connections - Postgres 9.2 Adrian Klaver <adrian.klaver@aklaver.com>
Re: Connections - Postgres 9.2 Venkata Balaji N <nag1010@gmail.com>
Re: Connections - Postgres 9.2 Lucas Possamai <drum.lucas@gmail.com>
Re: Connections - Postgres 9.2 Francisco Olarte <folarte@peoplecall.com>
Re: Connections - Postgres 9.2 "David G. Johnston" <david.g.johnston@gmail.com>
Re: Connections - Postgres 9.2 Sridhar N Bamandlapally <sridhar.bn1@gmail.com>
Re: Connections - Postgres 9.2 Lucas Possamai <drum.lucas@gmail.com>
Re: Connections - Postgres 9.2 Sridhar N Bamandlapally <sridhar.bn1@gmail.com>
Re: Connections - Postgres 9.2 Melvin Davidson <melvin6925@gmail.com>
Hello
Hi LucasOn 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 по дате отправления
