DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:cc:in-reply-to:mime-version
	:content-type:content-transfer-encoding:content-disposition
	:references;
	b=bhifJ3DCuAZRRFgduIQvQ/MZH1sYIpinx7Buphig3jsYReqor+qwpyWDWBKF7k/NyZ
	nZcbL361g9YkoQi4valw4BIESzJ5hptE2YcvmoxwfCwV+qw0ahwon1Xy30B/uavkZ/Dn
	iQvHx7UQocKuZOEaOSc36gLO3wF4/iG5fQWXA=
Message-ID: <dcc563d10809121047n34e16435i4f57e5a20c87da0c@mail.gmail.com>
Date: Fri, 12 Sep 2008 11:47:38 -0600
From: "Scott Marlowe" <scott.marlowe@gmail.com>
To: Vivek_Sharan <Vivek_Sharan@infosys.com>
Subject: Re: Heavy postgres process
Cc: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
In-Reply-To: 
 <5465CC59A600E2408FFBF84350B938345031E95B93@AUSMELMBX01.ad.infosys.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: 
 <5465CC59A600E2408FFBF84350B938345031E95B93@AUSMELMBX01.ad.infosys.com>

On Fri, Sep 12, 2008 at 2:12 AM, Vivek_Sharan <Vivek_Sharan@infosys.com> wrote:
> Hi Admin,
>
> I'm new to this I have few queries as listed below
>
> 1)      Number of connections made with a particular database.

Wait, how to find out how many connections there are, or how many can
a particular db handle.

For this kind of thing, look at the admin functions in the pgsql-sql docs:

http://www.postgresql.org/docs/8.3/interactive/functions-admin.html

specifically you want something like:

select datname from pg_stat_activity;
select datname, count(datname)  from pg_stat_activity group by datname;

> 2)      And how can I check which process (PID) is responsible for the
> connection and

That table up there ^^^

> 3)      what all can make a postgres process as heavy as 70-80 MB in size

you may not be measuring properly.  When you say it's using 70-80 MB
how do you know this?  The numbers you see in top aren't necessarily
what some folks think they ar.