Re: Archiving and recovering pg_stat_tmp

Поиск
Список
Период
Сортировка
От Sameer Thakur
Тема Re: Archiving and recovering pg_stat_tmp
Дата
Msg-id CABzZFEsVKLtTm8-y+SvRvUehsUfWjk+kMOEr3VnVzYDt7Lz-2w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Archiving and recovering pg_stat_tmp  (Jeff Janes <jeff.janes@gmail.com>)
Список pgsql-general

>Do you think that it is important to do so?  Are you experiencing problems which you believe are due to missing/out of date >activity statistics?  Or is this more for curiosity?
I am making specifications for a tool which captures query plan statistics. I wanted its behavior to be the same as statistics collector for everything except in the kind of statistics being collected. This is the same premise used by pg_stat_statements. Hence the question wrt PITR recovery.
    In the case of my tool there could be as case that user wants to see the information like 5 slowest queries after archive recovery. For this i would need to build in logic to ensure the stats file read in during recovery is in sync with that timeline. It sounds complicated so was wondering how statistics collector handled it.
Seems to me that the stats file is ignored in archive recovery mode,and deleted. This is consistent with its crash recovery behavior as well. 
regards
Sameer
 

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

Предыдущее
От: Jiří Pavlovský
Дата:
Сообщение: Re: utf8 errors
Следующее
От: Adarsh Sharma
Дата:
Сообщение: Re: Concatenate table name in Pl/Pgsql