Re: Heavy postgres process

Thanks for your reply but how would I calculate which processes are eating up more memory, When I check process list, its only postgres and apache processes running on my system and only postgres processes are heavy. System runs out of memory quickly.

Regards,
~Vivek

-----Original Message-----
From: Scott Marlowe [mailto:scott(dot)marlowe(at)gmail(dot)com]
Sent: Friday, September 12, 2008 11:18 PM
To: Vivek_Sharan
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] Heavy postgres process

On Fri, Sep 12, 2008 at 2:12 AM, Vivek_Sharan <Vivek_Sharan(at)infosys(dot)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.

**************** CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely
for the use of the addressee(s). If you are not the intended recipient, please
notify the sender by e-mail and delete the original message. Further, you are not
to copy, disclose, or distribute this e-mail or its contents to any other person and
any such actions are unlawful. This e-mail may contain viruses. Infosys has taken
every reasonable precaution to minimize this risk, but is not liable for any damage
you may sustain as a result of any virus in this e-mail. You should carry out your
own virus checks before opening the e-mail or attachment. Infosys reserves the
right to monitor and review the content of all messages sent to or from this e-mail
address. Messages sent to or from this e-mail address may be stored on the
Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***