Re: [ADMIN] Heavy postgres process

2008-09-17 Thread Vivek_Sharan
Yes that's true and that's planned. We will migrate to Oracle. But as of now need some pointers on solving the problem in hand. Regards, Vivek -Original Message- From: Guido Barosio [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2008 6:39 PM To: Vivek_Sharan

Re: [ADMIN] Heavy postgres process

2008-09-17 Thread Vivek_Sharan
I'm using postgres 7.4.5 Regards, Vivek -Original Message- From: Guido Barosio [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16, 2008 8:08 PM To: Vivek_Sharan Cc: Scott Marlowe; pgsql-admin@postgresql.org Subject: Re: [ADMIN] Heavy postgres process On Tue, Sep 16, 2008 at 1:

Re: [ADMIN] Heavy postgres process

2008-09-16 Thread Vivek_Sharan
age- From: Scott Marlowe [mailto:[EMAIL PROTECTED] Sent: Monday, September 15, 2008 9:24 PM To: Vivek_Sharan Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Heavy postgres process 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:3

Re: [ADMIN] Heavy postgres process

2008-09-15 Thread Vivek_Sharan
- 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 ne

[ADMIN] Heavy postgres process

2008-09-12 Thread Vivek_Sharan
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