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 86AF2536EA for ; Thu, 31 Mar 2005 09:52:24 +0100 (BST) 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 52563-09 for ; Thu, 31 Mar 2005 08:52:18 +0000 (GMT) Received: from mailin.kwsoft.de (mailin.kwsoft.de [213.164.67.82]) by svr1.postgresql.org (Postfix) with ESMTP id 2B55D53652 for ; Thu, 31 Mar 2005 09:52:16 +0100 (BST) Received: from localhost (localhost [127.0.0.1]) by mailin.kwsoft.de (Postfix) with ESMTP id 0709251EB8 for ; Thu, 31 Mar 2005 10:52:18 +0200 (CEST) Received: from localhost (localhost [127.0.0.1]) by mailin.kwsoft.de (Postfix) with ESMTP id DA91C51EB7 for ; Thu, 31 Mar 2005 10:52:16 +0200 (CEST) Received: from mailer.kwsoft.de (mailer.kwsoft.de [10.5.0.1]) by webmail.kwsoft.de (IMP) with HTTP for ; Thu, 31 Mar 2005 10:52:16 +0200 Message-ID: <1112259136.424bba40cf286@webmail.kwsoft.de> Date: Thu, 31 Mar 2005 10:52:16 +0200 From: lst_hoe01@kwsoft.de To: pgsql-admin@postgresql.org Subject: Re: Many persistant client connections References: <20050330090533.0dp4fmto0ckoossk@webtest.kwsoft.de> <60oed1rvr2.fsf@dba2.int.libertyrms.com> In-Reply-To: <60oed1rvr2.fsf@dba2.int.libertyrms.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit User-Agent: Internet Messaging Program (IMP) 3.2.6 X-Virus-Scanned: by amavisd-new at kwsoft.de X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.585 tagged_above=0 required=5 tests=AWL, FROM_ENDS_IN_NUMS, FROM_HAS_ULINE_NUMS, NO_REAL_NAME X-Spam-Level: X-Archive-Number: 200503/500 X-Sequence-Number: 16998 Zitat von Chris Browne : > lst_hoe01@kwsoft.de writes: > > i would like to know if there is something like the Oracle "shared > > server" possible with PostgreSQL. I have searched the archives but > > have not found any real discussion regarding this. > > > > We have two CTI applications opening 2-3 persistant connections to > > the address server (PostgreSQL). With 100 clients we get around 400 > > persistant connections eating up the server memory and have nothing > > to work most of the time. > > Sounds like a case for looking into pgpool... > > > > pgpool is a connection pool system implemented in C that can allow > sharing of connections for many cases like the one you describe. Thanks for the info. Is this the recommended way to handle many persistant client connections or are there other opinions/possibilities? Regards Andreas