Re: Stats processor not restarting - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Stats processor not restarting
Date
Msg-id 13948.1174404191@sss.pgh.pa.us
Whole thread Raw
In response to Re: Stats processor not restarting  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-hackers
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Magnus Hagander wrote:
>> I've noticed that if for example the autovacuum process dies (such as
>> with a kill -9 when testing my new shared mem implementation), only
>> autovac and bgwriter are restarted. The stats collector is terminated,
>> but not restarted. (Same goes for a regular backend, and not just
>> autovac)
>> 
>> Is there a reason for this, or is it a bug?

> I would say it is a bug, because the comments and code in ServerLoop()
> and reaper() say different.

There is code in pgstat_start that limits the frequency with which new
stats collectors can be spawned --- maybe your test case is hitting that?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: Stats processor not restarting
Next
From: Tom Lane
Date:
Subject: Re: Stats for multi-column indexes