X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id DE79D53EE8 for ; Mon, 25 Apr 2005 07:21:23 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 49317-04 for ; Mon, 25 Apr 2005 10:21:15 +0000 (GMT) Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.194]) by svr1.postgresql.org (Postfix) with ESMTP id 9D46B53F89 for ; Mon, 25 Apr 2005 07:21:13 -0300 (ADT) Received: by zproxy.gmail.com with SMTP id 34so2203241nzf for ; Mon, 25 Apr 2005 03:21:15 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=fEp73ADrrZx5wjAXPGnarFw6XJW4in8Y1ggrbU8/dVLBoDY/dD4+ksuKMMRueYdzXD9ghTwz5P9IN4PhZG4H7aCGTq/s1Bpb4N5alDyQK50g6T2/uaki+idXZ5BpuMNU6K6B0KQE3SRO3lHIB0uIdfLitdIJT8PKebraVjUDHkY= Received: by 10.36.9.12 with SMTP id 12mr475546nzi; Mon, 25 Apr 2005 03:21:15 -0700 (PDT) Received: by 10.36.74.19 with HTTP; Mon, 25 Apr 2005 03:21:15 -0700 (PDT) Message-ID: <674d1f8a05042503211b0ba14d@mail.gmail.com> Date: Mon, 25 Apr 2005 15:51:15 +0530 From: Gourish Singbal Reply-To: Gourish Singbal To: PgSQL Admin Subject: lots of idle connections open by application Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.26 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200504/357 X-Sequence-Number: 17370 Hi guys, We have an application using db-conection pooling through resin 2.1 connecting to postgresql 7.4.5 database We have seen that after some time many connections are kept open in idle state. Sometimes the connections reach the max_connections =3D 100 and hence no more clients can connect to the database. Guys, Whats a reasonable solution to this problem... ? --=20 Best, Gourish Singbal