On Thu, Oct 18, 2001 at 01:55:33PM -0400, Tom Lane wrote: > Andrew Hill <[EMAIL PROTECTED]> writes: > > Normally, 32 connections is heaps for what I need. However, I often get > > connections that seem to be doing nothing. For example: > > > [bash] > > \_ postmaster -i -D/var/pgsql/data -N 32 -B 64 > > \_ [postmaster] > > \_ /var/pgsql/bin/postgres 202.174.32.67 postgres anb idle > > \_ /var/pgsql/bin/postgres 202.174.32.68 postgres anb idle > > \_ [postmaster] > > \_ /var/pgsql/bin/postgres 203.34.190.137 postgres bmf idle > > \_ [postmaster] > > \_ [postmaster] > > \_ [postmaster] > > \_ [postmaster] > > \_ /var/pgsql/bin/postgres 202.174.32.8 radius bmf idle > > Curious. Can you attach to some of the unidentified processes with > a debugger, and get a stack traceback from 'em? Offhand I can't > think of a reason for 7.0 to have any subprocesses that haven't > changed their PS display. It would help to know what they are doing.
I believe the processes displayed as [foo] are paged out which is why you don't see their full commandlines. Regards, Lenny -- Lenny Mastrototaro VP System Operations HorizonLive.com [EMAIL PROTECTED] collaborate . interact . learn (212)813-3867 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
