idle processes in v7.1 ... not killable? - Mailing list pgsql-hackers
| From | The Hermit Hacker |
|---|---|
| Subject | idle processes in v7.1 ... not killable? |
| Date | |
| Msg-id | Pine.BSF.4.33.0104190956020.400-100000@mobile.hub.org Whole thread Raw |
| Responses |
Re: idle processes in v7.1 ... not killable?
(Tom Lane <tgl@sss.pgh.pa.us>)
|
| List | pgsql-hackers |
I tried to do a 'kill <pid>' like I would have in v7.0.3, doesn't affect
it ... so, how to get rid of idle process that have been sitting around
for a long time, without having to shutdown the database itself?
pgsql 64484 0.0 1.0 15352 10172 p4- I Sat08PM 0:00.15 postmaster: hordemgr horde 216.126.85.170 idle
(postgres)
pgsql 64760 0.0 1.0 15352 10420 p4- I Sat08PM 0:00.21 postmaster: hordemgr horde 216.126.85.170 idle
(postgres)
pgsql 94615 0.0 0.8 15336 8488 p4- I Sun12AM 0:00.09 postmaster: hordemgr horde 216.126.85.86 idle
(postgres)
pgsql 99711 0.0 0.9 15336 9688 p4- I Sun01AM 0:00.14 postmaster: hordemgr horde 216.126.85.188 idle
(postgres)
pgsql 99810 0.0 0.9 15352 9124 p4- I Sun01AM 0:00.12 postmaster: hordemgr horde 216.126.85.188 idle
(postgres)
pgsql 1768 0.0 0.8 15336 8112 p4- I Sun01AM 0:00.09 postmaster: hordemgr horde 216.126.85.86 idle
(postgres)
pgsql 8781 0.0 1.1 15368 11016 p4- I Sun09AM 0:00.23 postmaster: hordemgr horde 216.126.85.30 idle
(postgres)
pgsql 29503 0.0 1.1 15352 11052 p4- I Sun10AM 0:00.23 postmaster: hordemgr horde 216.126.85.30 idle
(postgres)
pgsql 29930 0.0 1.0 15352 10556 p4- I Sun11PM 0:00.15 postmaster: hordemgr horde 216.126.85.100 idle
(postgres)
pgsql 29985 0.0 1.0 15352 10192 p4- I Sun11PM 0:00.14 postmaster: hordemgr horde 216.126.85.100 idle
(postgres)
pgsql 57446 0.0 0.6 15336 6784 p4- I Mon09AM 0:00.06 postmaster: hordemgr horde 216.126.85.243 idle
(postgres)
pgsql 57961 0.0 0.7 15336 6884 p4- I Mon09AM 0:00.06 postmaster: hordemgr horde 216.126.85.243 idle
(postgres)
pgsql 98541 0.0 0.8 15352 8756 p4- I Mon11AM 0:00.10 postmaster: hordemgr horde 216.126.85.13 idle
(postgres)
pgsql 98601 0.0 0.7 15336 6796 p4- I Mon11AM 0:00.06 postmaster: hordemgr horde 216.126.85.13 idle
(postgres)
pgsql 16510 0.0 0.7 15352 7624 p4- I Mon01PM 0:00.07 postmaster: hordemgr horde 216.126.85.196 idle
(postgres)
pgsql 17052 0.0 0.7 15352 6936 p4- I Mon01PM 0:00.06 postmaster: hordemgr horde 216.126.85.196 idle
(postgres)
pgsql 86741 0.0 0.6 15336 6660 p4- I Mon10PM 0:00.06 postmaster: hordemgr horde 216.126.85.119 idle
(postgres)
pgsql 8388 0.0 0.6 15336 6484 p4- I Tue12AM 0:00.05 postmaster: hordemgr horde 216.126.85.95 idle
(postgres)
pgsql 27186 0.0 1.0 15368 10880 p4- I Tue09AM 0:00.24 postmaster: hordemgr horde 216.126.85.184 idle
(postgres)
pgsql 27512 0.0 0.9 15352 9616 p4- I Tue09AM 0:00.15 postmaster: hordemgr horde 216.126.85.184 idle
(postgres)
pgsql 91723 0.0 1.0 15368 10364 p4- I Tue12PM 0:00.16 postmaster: hordemgr horde 216.126.85.194 idle
(postgres)
pgsql 45351 0.0 0.6 15336 5952 p4- I 10:03AM 0:00.04 postmaster: hordemgr horde 216.126.85.186 idle
(postgres)
pgsql 35967 0.0 0.5 15336 4960 ?? I 8:53AM 0:00.03 postmaster: hordemgr horde 216.126.84.1 idle (postgres)
pgsql 36678 0.0 0.0 1008 312 p4 R+ 8:55AM 0:00.00 grep hordemgr
pgsql 45200 0.0 0.7 15356 6828 p4- I 10:03AM 0:00.06 postmaster: hordemgr horde 216.126.85.186 idle
(postgres)
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org
pgsql-hackers by date: