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 34B2B535D2 for ; Wed, 30 Mar 2005 08:06:02 +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 64859-09 for ; Wed, 30 Mar 2005 07:05:33 +0000 (GMT) Received: from mailin.kwsoft.de (mailin.kwsoft.de [213.164.67.82]) by svr1.postgresql.org (Postfix) with ESMTP id AFCFC535B1 for ; Wed, 30 Mar 2005 08:05:32 +0100 (BST) Received: from localhost (localhost [127.0.0.1]) by mailin.kwsoft.de (Postfix) with ESMTP id 4184A51E0B for ; Wed, 30 Mar 2005 09:05:34 +0200 (CEST) Received: from localhost (localhost [127.0.0.1]) by mailin.kwsoft.de (Postfix) with ESMTP id 345B951E09 for ; Wed, 30 Mar 2005 09:05:33 +0200 (CEST) Received: from ( [unknown]) by webtest.kwsoft.de (Horde) with HTTP for ; Wed, 30 Mar 2005 09:05:33 +0200 Message-ID: <20050330090533.0dp4fmto0ckoossk@webtest.kwsoft.de> Date: Wed, 30 Mar 2005 09:05:33 +0200 From: lst_hoe01@kwsoft.de To: pgsql-admin@postgresql.org Subject: Many persistant client connections MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 7bit User-Agent: Internet Messaging Program (IMP) H3 (4.0.2) X-Virus-Scanned: by amavisd-new at kwsoft.de X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200503/474 X-Sequence-Number: 16972 Hello 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. Thanxs for any help Andreas