VACUUM activiy can make any process size so much heavy...
Suresh Borse wrote:
Hi,
Try to monitor the o/p of following command.
psql > select * from pg_Stat_activity;
It gives all the connection detail.
On Fri, 2008-09-12 at 18:12 +1000, Vivek_Sharan wrote:
Hi Admin,
I’m new to this I have few queries as listed below
1) Number of connections made with a particular database.
2) And how can I check which process (PID) is responsible for the
connection and
3) what all can make a postgres process as heavy as 70-80 MB in size
Need to know these answers ASAP so I would highly appreciate if you
can find time to answer my questions.
Regards,
* ~Vivek *
**************** 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***
Thanks & Regards,
Suresh Borse
(D BA )
______________________________________________________
________________________________ _ __
* DIRECTION SOFTWARE SOLUTIONS *
5, Brady Gladys Plaza, 1/447, Senapati Bapat Marg, Lower Parel, M
umbai - 400 013
Tel. : 91 22 66615000 (Ext: 35 0 ) Fax : 91 22
24911046
Cell : 91 9 4 2 2 239338 Site :
www.direction.biz <http://www.direction.biz/>
___________________________________________________
_____________________________________ _
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
