Run top, hit M and the attach the output to a reply here and we'll take a look.
On Mon, Sep 15, 2008 at 5:33 AM, Vivek_Sharan <[EMAIL PROTECTED]> wrote: > 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:[EMAIL PROTECTED] > Sent: Friday, September 12, 2008 11:18 PM > To: Vivek_Sharan > Cc: pgsql-admin@postgresql.org > Subject: Re: [ADMIN] Heavy postgres process > > On Fri, Sep 12, 2008 at 2:12 AM, Vivek_Sharan <[EMAIL PROTECTED]> 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*** > -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
