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 <Vivek_Sharan@xxxxxxxxxxx> 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:scott.marlowe@xxxxxxxxx] > Sent: Friday, September 12, 2008 11:18 PM > To: Vivek_Sharan > Cc: pgsql-admin@xxxxxxxxxxxxxx > Subject: Re: [ADMIN] Heavy postgres process > > On Fri, Sep 12, 2008 at 2:12 AM, Vivek_Sharan <Vivek_Sharan@xxxxxxxxxxx> 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*** >
