Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.84_2)
	(envelope-from
 <pgsql-admin-owner+M46052=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
	id 1c8N36-0005pM-85
	for pgsql-admin@arkaria.postgresql.org; Sun, 20 Nov 2016 08:00:28 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
	by malur.postgresql.org with smtp (Exim 4.84_2)
	(envelope-from
 <pgsql-admin-owner+M46052=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
	id 1c8N34-0007IP-Pv
	for pgsql-admin@arkaria.postgresql.org; Sun, 20 Nov 2016 08:00:26 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.84_2)
	(envelope-from <sql-pgsql-admin@m.gmane.org>)
	id 1c8N1N-00054C-Kt
	for pgsql-admin@postgresql.org; Sun, 20 Nov 2016 07:58:41 +0000
Received: from [195.159.176.226] (helo=blaine.gmane.org)
	by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.84_2)
	(envelope-from <sql-pgsql-admin@m.gmane.org>)
	id 1c8N1J-0006ng-K4
	for pgsql-admin@postgresql.org; Sun, 20 Nov 2016 07:58:40 +0000
Received: from list by blaine.gmane.org with local (Exim 4.84_2)
	(envelope-from <sql-pgsql-admin@m.gmane.org>)
	id 1c8N1E-0007H0-K5
	for pgsql-admin@postgresql.org; Sun, 20 Nov 2016 08:58:32 +0100
X-Injected-Via-Gmane: http://gmane.org/
To: pgsql-admin@postgresql.org
From: Thomas Kellerer <spam_eater@gmx.net>
Subject: Re: Why are a lot of ROLLBACK queries in idle state
Date: Sun, 20 Nov 2016 08:58:26 +0100
Lines: 15
Message-ID: <o0rl2u$8co$1@blaine.gmane.org>
References: <1479462927604-5930917.post@n3.nabble.com>
 <o0mkvn$d1p$1@blaine.gmane.org> <1479470163236-5930934.post@n3.nabble.com>
 <o0mu37$bnq$1@blaine.gmane.org> <1479623888550-5931144.post@n3.nabble.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding: 7bit
X-Complaints-To: usenet@blaine.gmane.org
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.8.1.21)
 Gecko/20090302 Thunderbird/2.0.0.21 Mnenhy/0.7.5.666
In-Reply-To: <1479623888550-5931144.post@n3.nabble.com>
X-Host-Lookup-Failed: Reverse DNS lookup failed for 195.159.176.226 (failed)
X-Pg-Spam-Score: -1.1 (-)
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

rajan schrieb am 20.11.2016 um 07:38:
> thanks for the reply.
>
> how do I kill these idle sessions? And if I do, will it cause any issues?

Why do you think you need to kill them?

An idle connection is not really a problem and keeping them around for re-use is exactly what connection pools are doing.

If you think those connections are a problem, you should rather investigate why your applications doesn't close, not blindly kill them.








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