From: C K <shreeseva.it@gmail.com>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Managing connections
Date: Wed, 6 Aug 2008 22:34:06 +0530
Message-ID: <d3561eb00808061004w41371ee3h3d9a87be9ed9cd20@mail.gmail.com> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: shreeseva.it@gmail.com
Subject: Re: Managing connections
In-Reply-To: <d3561eb00808061004w41371ee3h3d9a87be9ed9cd20@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox