Re: Connections - Postgres 9.2 - Mailing list pgsql-general

From Francisco Olarte
Subject Re: Connections - Postgres 9.2
Date
Msg-id CA+bJJbzmb_atz5mTn2X3XnhWTLc0g0swgDOG6htbiDmyWLz9ng@mail.gmail.com
Whole thread Raw
In response to Connections - Postgres 9.2  (Lucas Possamai <drum.lucas@gmail.com>)
Responses Re: Connections - Postgres 9.2
List 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 by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Toolchain for extensions (language C, Visual Studio 2013 / 2015)
Next
From: Charles Clavadetscher
Date:
Subject: Re: Connections - Postgres 9.2