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?
|
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: