
I have a bunch of these just sitting there:

pgsql 86144  0.0  0.0   304  120  p3  D+    5:17PM   0:00.00 grep udmsearch
pgsql 69312  0.0  3.6 21652 18808  p1  S    12:20PM  10:09.68 postmaster: /pgsql/bin/postgres pgsql 216.126.84.1 udmsearch /pgsql/bin/postgres pgsql 216.126.84.1 udmsearch waiting (postgres)
pgsql 83848  0.0  3.7 22472 19300  p1  D     4:24PM   3:02.53 postmaster: /pgsql/bin/postgres pgsql 216.126.84.1 udmsearch /pgsql/bin/postgres pgsql 216.126.84.1 udmsearch (postgres)
pgsql 83906  0.0  1.2 21436 6044  p1  S     4:25PM   0:00.10 postmaster: /pgsql/bin/postgres pgsql 216.126.84.1 udmsearch /pgsql/bin/postgres pgsql 216.126.84.1 udmsearch waiting (postgres)
pgsql 84138  0.0  0.8 21436 4256  p1  S     4:30PM   0:00.08 postmaster: /pgsql/bin/postgres pgsql 216.126.84.1 udmsearch /pgsql/bin/postgres pgsql 216.126.84.1 udmsearch waiting (postgres)
pgsql 84190  0.0  0.8 21436 4200  p1  S     4:30PM   0:00.07 postmaster: /pgsql/bin/postgres pgsql 216.126.84.1 udmsearch /pgsql/bin/postgres pgsql 216.126.84.1 udmsearch waiting (postgres)
pgsql 84251  0.0  0.8 21436 4292  p1  S     4:32PM   0:00.08 postmaster: /pgsql/bin/postgres pgsql 216.126.84.1 udmsearch /pgsql/bin/postgres pgsql 216.126.84.1 udmsearch waiting (postgres)
pgsql 84610  0.0  0.8 21436 4272  p1  S     4:40PM   0:00.07 postmaster: /pgsql/bin/postgres pgsql 216.126.84.1 udmsearch /pgsql/bin/postgres pgsql 216.126.84.1 udmsearch waiting (postgres)
pgsql 84863  0.0  0.8 21440 4184  p1  S     4:46PM   0:00.06 postmaster: /pgsql/bin/postgres pgsql 216.126.84.1 udmsearch /pgsql/bin/postgres pgsql 216.126.84.1 udmsearch waiting (postgres)
pgsql 84910  0.0  0.8 21440 4384  p1  S     4:47PM   0:00.07 postmaster: /pgsql/bin/postgres pgsql 216.126.84.1 udmsearch /pgsql/bin/postgres pgsql 216.126.84.1 udmsearch waiting (postgres)
pgsql 84990  0.0  0.8 21440 4312  p1  S     4:50PM   0:00.06 postmaster: /pgsql/bin/postgres pgsql 216.126.84.1 udmsearch /pgsql/bin/postgres pgsql 216.126.84.1 udmsearch waiting (postgres)
pgsql 85010  0.0  0.8 21440 4268  p1  S     4:50PM   0:00.06 postmaster: /pgsql/bin/postgres pgsql 216.126.84.1 udmsearch /pgsql/bin/postgres pgsql 216.126.84.1 udmsearch waiting (postgres)
pgsql 85030  0.0  0.8 21440 4252  p1  S     4:51PM   0:00.09 postmaster: /pgsql/bin/postgres pgsql 216.126.84.1 udmsearch /pgsql/bin/postgres pgsql 216.126.84.1 udmsearch waiting (postgres)
pgsql 85035  0.0  0.8 21440 4328  p1  S     4:51PM   0:00.06 postmaster: /pgsql/bin/postgres pgsql 216.126.84.1 udmsearch /pgsql/bin/postgres pgsql 216.126.84.1 udmsearch waiting (postgres)
pgsql 85116  0.0  0.8 21440 4296  p1  S     4:53PM   0:00.07 postmaster: /pgsql/bin/postgres pgsql 216.126.84.1 udmsearch /pgsql/bin/postgres pgsql 216.126.84.1 udmsearch waiting (postgres)
pgsql 85120  0.0  0.8 21440 4324  p1  S     4:53PM   0:00.06 postmaster: /pgsql/bin/postgres pgsql 216.126.84.1 udmsearch /pgsql/bin/postgres pgsql 216.126.84.1 udmsearch waiting (postgres)
pgsql 85714  0.0  0.9 21444 4628  p1  S     5:08PM   0:00.07 postmaster: /pgsql/bin/postgres pgsql 216.126.84.1 udmsearch /pgsql/bin/postgres pgsql 216.126.84.1 udmsearch waiting (postgres)
pgsql 85733  0.0  0.8 21456 4412  p1  S     5:08PM   0:00.07 postmaster: /pgsql/bin/postgres pgsql 216.126.84.1 udmsearch /pgsql/bin/postgres pgsql 216.126.84.1 udmsearch waiting (postgres)
pgsql 85868  0.0  0.9 21444 4492  p1  S     5:11PM   0:00.06 postmaster: /pgsql/bin/postgres pgsql 216.126.84.1 udmsearch /pgsql/bin/postgres pgsql 216.126.84.1 udmsearch waiting (postgres)
pgsql 85951  0.0  0.8 21444 4236  p1  S     5:13PM   0:00.05 postmaster: /pgsql/bin/postgres pgsql 216.126.84.1 udmsearch /pgsql/bin/postgres pgsql 216.126.84.1 udmsearch waiting (postgres)
pgsql 85976  0.0  0.8 21444 4276  p1  S     5:13PM   0:00.08 postmaster: /pgsql/bin/postgres pgsql 216.126.84.1 udmsearch /pgsql/bin/postgres pgsql 216.126.84.1 udmsearch waiting (postgres)
pgsql 86039  0.0  0.8 21444 4344  p1  S     5:14PM   0:00.08 postmaster: /pgsql/bin/postgres pgsql 216.126.84.1 udmsearch /pgsql/bin/postgres pgsql 216.126.84.1 udmsearch waiting (postgres)
> date
Wed Jul 12 17:17:24 EDT 2000
> 

I'm leaving them there for now ... any clue how to to check what they are
waiting for?  That one at the top has been waiting since 12:30 and its now
17:17 :)  Very patient processes, eh? :)


Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
Systems Administrator @ hub.org 
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org 


Wed, 12 Jul 2000 18:17:54 -0300 (ADT)
The Hermit Hacker <scrappy@hub.org>
[7.0.2] waiting ... ?