Idle processes are not uncommon on a database. Basically their client applications that don't have anything for the
databaseto 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@sss.pgh.pa.us]
Sent: Thursday, February 19, 2004 1:30 AM
To: jerome@gmanmi.tv
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Knowing postgres processes..
JM <jerome@gmanmi.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@postgresql.org
