Re: PostgreSQL Connections? - Mailing list pgsql-general

From Shoaib Mir
Subject Re: PostgreSQL Connections?
Date
Msg-id bf54be870701100252gf2cbe5ane19f1d13a8ab28da@mail.gmail.com
Whole thread Raw
In response to PostgreSQL Connections?  (Ashish Karalkar <ashish_karalkar@yahoo.com>)
Responses Re: PostgreSQL Connections?  (Ashish Karalkar <ashish_karalkar@yahoo.com>)
List pgsql-general
Can you show us the output for:

ps auxwww | grep ^postgres

that should explain a little more...

-------------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com )

On 1/10/07, Ashish Karalkar <ashish_karalkar@yahoo.com> wrote:
Hello All,
I am running PostgresSQL 8.2 on Redhat Linux 4.
When I look for the processes that are using postgres
using ps aux|more
I got lots of Idle processes with servers own IP
address. Can anybody please tell me why this is
happening.

Also there are multiple processes for my single
client(same IP) of which maximum are idle. are these
processes means connection or there is a single
connection starting  many processes.



I am having max connection =200



__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: Operator performance question
Next
From: Ashish Karalkar
Date:
Subject: SP in PostgreSQL