Re: Location for pgstat.stat

Поиск
Список
Период
Сортировка
От Magnus Hagander
Тема Re: Location for pgstat.stat
Дата
Msg-id 486A86D5.7060501@hagander.net
обсуждение исходный текст
Ответ на Re: Location for pgstat.stat  (Alvaro Herrera <alvherre@commandprompt.com>)
Ответы Re: Location for pgstat.stat
Список 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 по дате отправления:

Предыдущее
От: Gregory Stark
Дата:
Сообщение: Re: A new take on the foot-gun meme
Следующее
От: Greg Smith
Дата:
Сообщение: Re: Location for pgstat.stat