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***
