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
