Re: Heavy postgres process

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/>
> ___________________________________________________
> _____________________________________ _
>