Re: Connections - Postgres 9.2

From: Charles Clavadetscher <clavadetscher(at)swisspug(dot)org>
To: Lucas Possamai <drum(dot)lucas(at)gmail(dot)com>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Connections - Postgres 9.2
Date: 2016-05-16 16:26:41
Message-ID: 5BA091E6-ABFB-48A2-9FED-68A2DD7A9AEF@swisspug.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello

> On 16.05.2016, at 04:10, Lucas Possamai <drum(dot)lucas(at)gmail(dot)com> wrote:
>
> Hi guys,
>
> <Screen Shot 2016-05-16 at 2.06.20 PM.png>
>
> Those IDLE connections, might be because the user/application didn't commit the transaction?

I think that idle means that a client is connected but is doing nothing. Possibly It includes terminated processes without a commit, since they do nothing, but I am not sure that you can assume that all connections are uncommitted transactions.

Bye
Charles

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2016-05-16 16:27:33 Re: Connections - Postgres 9.2
Previous Message Oleg Bartunov 2016-05-16 14:09:23 Re: Ascii Elephant for text based protocols - Final