On Tue, 2007-01-09 at 21:48 -0800, Ashish Karalkar 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.
>
You probably have clients accessing postgresql and holding the
connection open, perhaps in a connection pool. Do you have web
applications accessing the database?
Regards,
Jeff Davis
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
