clear defunct entries from pg_stat_activity

Поиск
Список
Период
Сортировка
От Robert Treat
Тема clear defunct entries from pg_stat_activity
Дата
Msg-id 1077924017.2784.51.camel@camel
обсуждение исходный текст
Ответы Re: clear defunct entries from pg_stat_activity  (Jan Wieck <JanWieck@Yahoo.com>)
Список pgsql-general
http://archives.postgresql.org/pgsql-general/2003-11/msg00581.php

In the above Jan Wieck mentions a bug that occurs in pg 7.3.4 that
causes a crashing backend to hang around in the stats until the slot is
reused, due to the message that tells that the backend terminates is
never sent to the collector daemon.

I'm curious if anyone knows if this was fixed in 7.4, and perhaps more
importantly if there is a way to clear these entries in 7.3.4.  (I was
thinking perhaps some entries in the stats tables but didn't find
anything...)


Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL


В списке pgsql-general по дате отправления:

Предыдущее
От: Mike Nolan
Дата:
Сообщение: Restoring a table with a different name
Следующее
От: Shane Wegner
Дата:
Сообщение: Re: efficient storing of urls