Re: Stats Collector Oddity

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Stats Collector Oddity
Дата
Msg-id 20277.1166718627@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Stats Collector Oddity  (Chris Browne <cbbrowne@acm.org>)
Список pgsql-hackers
Chris Browne <cbbrowne@acm.org> writes:
> There isn't any way, short of restarting the postmaster, to get rid of
> that PID, is there?

The entry will get overwritten when that BackendId slot gets re-used,
so just starting enough concurrent backends should do it.  (Since
incoming backends always take the lowest free slot, the fact that the
dead entry has persisted awhile means that it must have a number higher
than your normal number of concurrent sessions ... which is evidence
in favor of the idea that it happened during a load spike ...)
        regards, tom lane


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

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: column ordering, was Re: [PATCHES] Enums patch v2
Следующее
От: Lukas Kahwe Smith
Дата:
Сообщение: Re: Release 8.2.0 done, 8.3 development starts