Re: Stats Collector Oddity - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Stats Collector Oddity
Date
Msg-id 20277.1166718627@sss.pgh.pa.us
Whole thread Raw
In response to Re: Stats Collector Oddity  (Chris Browne <cbbrowne@acm.org>)
List 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 by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: column ordering, was Re: [PATCHES] Enums patch v2
Next
From: Lukas Kahwe Smith
Date:
Subject: Re: Release 8.2.0 done, 8.3 development starts