Postgres Pro
Downloads
Home   >   mailing lists

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

From Melvin Davidson
Subject Re: Connections - Postgres 9.2
Date
Msg-id CANu8FizfqeVuRtHXJUKEugeM+-vjy0UY4GN3rco+xKx4zWHo0w@mail.gmail.com
Whole thread Raw
In response to Connections - Postgres 9.2  (Lucas Possamai <drum.lucas@gmail.com>)
List pgsql-general
Tree view


On Sun, May 15, 2016 at 10:10 PM, Lucas Possamai <drum.lucas@gmail.com> wrote:
Hi guys,

Inline images 1

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

No, IDLE connections means the user (or application) connected and did not disconnect.
IDLE IN TRANSACTION means the user (or application) started a transaction and did not commit (yet).

--
Melvin Davidson
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.
Attachment

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Any difference between commit/rollback when only temp tables and \copy are used
Next
From: "David G. Johnston"
Date:
Subject: Re: Connections - Postgres 9.2