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 D648E53650 for ; Mon, 25 Apr 2005 07:52:12 -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 55375-01 for ; Mon, 25 Apr 2005 10:52:09 +0000 (GMT) Received: from mailin.kwsoft.de (mailin.kwsoft.de [213.164.67.82]) by svr1.postgresql.org (Postfix) with ESMTP id ACD9F5337C for ; Mon, 25 Apr 2005 07:52:07 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by mailin.kwsoft.de (Postfix) with ESMTP id EE61D51E11 for ; Mon, 25 Apr 2005 12:52:10 +0200 (CEST) Received: from localhost (localhost [127.0.0.1]) by mailin.kwsoft.de (Postfix) with ESMTP id B30C251E10 for ; Mon, 25 Apr 2005 12:52:09 +0200 (CEST) Received: from mailer.kwsoft.de (mailer.kwsoft.de [10.5.0.1]) by webmail.kwsoft.de (Horde MIME library) with HTTP for ; Mon, 25 Apr 2005 12:52:09 +0200 Message-ID: <20050425125209.i04m4d04k7k8ggk8@webmail.kwsoft.de> Date: Mon, 25 Apr 2005 12:52:09 +0200 From: lst_hoe01@kwsoft.de To: PgSQL Admin Subject: Re: lots of idle connections open by application References: <674d1f8a05042503211b0ba14d@mail.gmail.com> In-Reply-To: <674d1f8a05042503211b0ba14d@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format="flowed" Content-Disposition: inline Content-Transfer-Encoding: 7bit User-Agent: Internet Messaging Program (IMP) H3 (4.0.3-RC1) X-Virus-Scanned: by amavisd-new at kwsoft.de X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.854 tagged_above=0 required=5 tests=AWL, FROM_ENDS_IN_NUMS, FROM_HAS_ULINE_NUMS, NO_REAL_NAME X-Spam-Level: X-Archive-Number: 200504/358 X-Sequence-Number: 17371 Zitat von Gourish Singbal : > 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 = 100 and hence no more clients > can connect to the database. > > Guys, Whats a reasonable solution to this problem... ? PgPool was suggested to me some time ago but i never tried it until now. See http://pgpool.projects.postgresql.org/ Regards Andreas