Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id C457165040C for ; Wed, 6 Aug 2008 14:04:18 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 35700-07 for ; Wed, 6 Aug 2008 14:04:12 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from fg-out-1718.google.com (fg-out-1718.google.com [72.14.220.159]) by postgresql.org (Postfix) with ESMTP id 3C13C65043C for ; Wed, 6 Aug 2008 14:04:08 -0300 (ADT) Received: by fg-out-1718.google.com with SMTP id 16so9749fgg.23 for ; Wed, 06 Aug 2008 10:04:06 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:mime-version:content-type; bh=ZEiF9IYrXA+locDON5lB0nUYB8I+h494pZLOpEKy/k4=; b=JyJeQraS8PkB2hjcXDZjV14dnBxqaHXqfVpSlOuydu26UfjT7U1/0jS/l4WRvmaBJc R8aNLnYnnrl8FTl40ej5Q7aLV04ofr0KRLUKBgPvNQgsjJ4QUw9IM9xqGkvYBtZd0DCT U0WELfKE0qQZIGWkqvmQFMJuX1EQAWh7LPWwQ= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type; b=B7/GB6MG9RpWZwwCyVQNIDk4CIbspvkhmZfkOxxlpCJvfT6h4uvR+hq0T02u+ELniO QfQcaS3Q5x/AKk9DpxTRR7ZnHz93GOGf2QPYtNC1VHI2b/MZL8ckQNG2JY3D6Bq9yZ9b GAHAt69sFgAOvOMcn04HE/u73R3azBXvYhd/8= Received: by 10.86.90.13 with SMTP id n13mr983771fgb.3.1218042246901; Wed, 06 Aug 2008 10:04:06 -0700 (PDT) Received: by 10.86.71.10 with HTTP; Wed, 6 Aug 2008 10:04:06 -0700 (PDT) Message-ID: Date: Wed, 6 Aug 2008 22:34:06 +0530 From: "C K" To: "pgsql-admin@postgresql.org" Subject: Managing connections MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_8814_4808563.1218042246890" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200808/24 X-Sequence-Number: 29869 ------=_Part_8814_4808563.1218042246890 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Dear Friends, I want to know if I open a table to view the data a new connection is opened. If I open another table/execute a query does a another new connection is opened? As per manual, I know that for a database cluster and the same port a postgresql instance runs. But if we run multiple SQL statements from same client machine with same username, does postgresql creates a new instance? If yes, how to manage memory? (As per my observations, normally each postgresql instance takes 5-10 MB. So if we have to manage simultenious 1000 connections, it will require 1000*5MB=5GB + system memory requirements (approx. 1 GB) = total 6 GB (min.) Does this is correct?) Please give the details. I am using Win XP Pro with PostgreSQL 8.3. Thanks CPK -- Keep your Environment clean and green. ------=_Part_8814_4808563.1218042246890 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline
Dear Friends,
I want to know if I open a table to view the data a new connection is opened. If I open another table/execute a query does a another new connection is opened? As per manual, I know that for a database cluster and the same port a postgresql instance runs. But if we run multiple SQL statements from same client machine with same username, does postgresql creates a new instance? If yes, how to manage memory? (As per my observations, normally each postgresql instance takes 5-10 MB. So if we have to manage simultenious 1000 connections, it will require 1000*5MB=5GB + system memory requirements (approx. 1 GB) = total 6 GB (min.) Does this is correct?)
Please give the details. I am using Win XP Pro with PostgreSQL 8.3.
Thanks
CPK

--
Keep your Environment clean and green.
------=_Part_8814_4808563.1218042246890--