Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from
	<pgsql-admin-owner+M40679=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
	id 1U09Qa-0005Cj-Iw
	for pgsql-admin@arkaria.postgresql.org; Tue, 29 Jan 2013 11:32:36 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
	by malur.postgresql.org with smtp (Exim 4.72) (envelope-from
	<pgsql-admin-owner+M40679=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
	id 1U09Qa-00007S-3h
	for pgsql-admin@arkaria.postgresql.org; Tue, 29 Jan 2013 11:32:36 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <flavio@4linux.com.br>) id 1U09QZ-00007N-DY
	for pgsql-admin@postgresql.org; Tue, 29 Jan 2013 11:32:35 +0000
Received: from zcs.4linux.com.br ([107.23.21.113])
	by magus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <flavio@4linux.com.br>) id 1U09QW-0000YF-7N
	for pgsql-admin@postgresql.org; Tue, 29 Jan 2013 11:32:34 +0000
Received: from localhost (localhost [127.0.0.1])
	by zcs.4linux.com.br (Postfix) with ESMTP id 9BE87641328;
	Tue, 29 Jan 2013 09:32:30 -0200 (BRST)
X-Virus-Scanned: amavisd-new at 4linux.com.br
Received: from zcs.4linux.com.br ([127.0.0.1])
	by localhost (zcs.4linux.com.br [127.0.0.1]) (amavisd-new, port 10024)
	with ESMTP id OJuznp8_vBCQ; Tue, 29 Jan 2013 09:32:30 -0200 (BRST)
Received: from localhost (localhost [127.0.0.1])
	by zcs.4linux.com.br (Postfix) with ESMTP id 39A8064132A;
	Tue, 29 Jan 2013 09:32:30 -0200 (BRST)
X-Virus-Scanned: amavisd-new at 4linux.com.br
Received: from zcs.4linux.com.br ([127.0.0.1])
	by localhost (zcs.4linux.com.br [127.0.0.1]) (amavisd-new, port 10026)
	with ESMTP id IJFpS6pvqqf6; Tue, 29 Jan 2013 09:32:29 -0200 (BRST)
Received: from [192.168.43.11] (unknown [186.197.18.3])
	by zcs.4linux.com.br (Postfix) with ESMTPSA id 0B4EC641328;
	Tue, 29 Jan 2013 09:32:26 -0200 (BRST)
Message-ID: <5107B343.4070807@4linux.com.br>
Date: Tue, 29 Jan 2013 09:32:19 -0200
From: Flavio Henrique Araque Gurgel <flavio@4linux.com.br>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
	rv:17.0) Gecko/20130110 Thunderbird/17.0.2
MIME-Version: 1.0
To: Sathish Reddy Yelala <sathishy040@gmail.com>
CC: pgsql-admin@postgresql.org
Subject: Re: PGSQL-IDLE connection problem
References: 
 <CAD4_txzfCHiMth-+ke0Gdkub1gi8m=M6kahdeK6SunzFujcC4g@mail.gmail.com>
In-Reply-To: 
 <CAD4_txzfCHiMth-+ke0Gdkub1gi8m=M6kahdeK6SunzFujcC4g@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable
X-Pg-Spam-Score: -2.4 (--)
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org


Em 28-01-2013 07:12, Sathish Reddy Yelala escreveu:
> Hi,
>
>      we had problem with <IDLE> connections.when we start the database
> there huge number of connections goes to <IDLE> which leads to database
> access slow.

These connections are opened by your client application, not by PostgreSQL.

>     How can we prevent the <IDLE> connections and also where we can see
> the <IDLE> connection query so that we can identify.

You should consider looking at your application and how it handles the=20
connections it opens. What kind of application you have, distributed=20
clients or application server?

There's nothing to see about connections in <IDLE> state. They are doing=20
nothing, there's no query or transaction. They are just open connections.

Consider looking at the view pg_stat_activity. There you can see=20
username, IP and other things about these connections.

Regards,

__________________________________
Flavio Henrique A. Gurgel
L=EDder de Projetos Especiais
Consultoria, Projetos & Treinamentos 4LINUX
Tel1: +55-11.2125-4747 ou 2125-4748
www.4linux.com.br
email: flavio@4linux.com.br
______________________________
FREE SOFTWARE SOLUTIONS


--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin