Thread: Why reset pgstat during recovery



On 2021/04/02 18:41, 蔡梦娟(玊于) wrote:
>
>  Hi, all
>
>  I want to know why call pgstat_reset_all function during recovery
> process,  under what circumstances the data will be invalid after recovery?

If my understanding is right, PITR is the case. Now, the stats files are
generated as a one-time snapshot. This means that the stats counters
saved at last may not be valid for the specific point in time.

FWIW, there was a related discussion([1]) although the behavior is not
changed yet.

[1] https://www.postgresql.org/message-id/1416.1479760254%40sss.pgh.pa.us

Regards,
--
Masahiro Ikeda
NTT DATA CORPORATION