Re: Knowing postgres processes..

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