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 4CF5953808 for ; Wed, 30 Mar 2005 17:14:09 +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 45089-01 for ; Wed, 30 Mar 2005 16:14:04 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 4E475534D9 for ; Wed, 30 Mar 2005 17:14:04 +0100 (BST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id j2UGE42a045382 for ; Wed, 30 Mar 2005 16:14:04 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id j2UG4380042111 for pgsql-admin@postgresql.org; Wed, 30 Mar 2005 16:04:03 GMT (envelope-from news) From: Chris Browne X-Newsgroups: pgsql.admin Subject: Re: Many persistant client connections Date: Wed, 30 Mar 2005 10:36:33 -0500 Organization: cbbrowne Computing Inc Lines: 24 Message-ID: <60oed1rvr2.fsf@dba2.int.libertyrms.com> References: <20050330090533.0dp4fmto0ckoossk@webtest.kwsoft.de> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org User-Agent: Gnus/5.1006 (Gnus v5.10.6) XEmacs/21.4 (Jumbo Shrimp, linux) Cancel-Lock: sha1:9iDsPTxnwskaXN2dKBxCIMluLlI= To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200503/479 X-Sequence-Number: 16977 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. -- (format nil "~S@~S" "cbbrowne" "cbbrowne.com") http://www3.sympatico.ca/cbbrowne/postgresql.html "The present need for security products far exceeds the number of individuals capable of designing secure systems. Consequently, industry has resorted to employing folks and purchasing "solutions" from vendors that shouldn't be let near a project involving securing a system." -- Lucky Green