Re: Location for pgstat.stat - Mailing list pgsql-hackers

From Magnus Hagander
Subject Re: Location for pgstat.stat
Date
Msg-id 486A86D5.7060501@hagander.net
Whole thread Raw
In response to Re: Location for pgstat.stat  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: Location for pgstat.stat  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Alvaro Herrera wrote:
> Magnus Hagander wrote:
> 
>> Not sure. I guess my own personal concern would be how badly is
>> autovacuum affected by having to start off a blank set of stats? Any
>> other uses I have I think are capable of dealing with reset-to-zero states.
> 
> Well, it doesn't :-)  No database or table will be processed until stat
> entries are created, and then I think it will first wait until enough
> activity gathers to take any actions at all.

That's not actualliy not affected, but it does seem like it wouldn't be
a very big issue. If one table was just about to be vacuumed or
analyzed, this would just push it up to twice the threshold, right?

//Magnus



pgsql-hackers by date:

Previous
From: Gregory Stark
Date:
Subject: Re: A new take on the foot-gun meme
Next
From: Greg Smith
Date:
Subject: Re: Location for pgstat.stat