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:[EMAIL PROTECTED] Sent: Thursday, February 19, 2004 1:30 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: [ADMIN] Knowing postgres processes.. JM <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
