Re: Knowing postgres processes..

Idle processes are not uncommon on a database. Basically their client applications that don't have anything for the database to do at the present time. Now if they persist for a long period of time without ever changing state to active, then something is probably wrong.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Thursday, February 19, 2004 1:30 AM
To: jerome(at)gmanmi(dot)tv
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] Knowing postgres processes..

JM <jerome(at)gmanmi(dot)tv> writes:
> this are processes running on my box. is it normal to see
> "idle" processes?

That says you've got client processes holding open connections without
doing anything. You probably want to look at your client-side logic.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org