log_checkpoints and restartpoint

Поиск
Список
Период
Сортировка
От Fujii Masao
Тема log_checkpoints and restartpoint
Дата
Msg-id AANLkTinQmuuC1RDkPHt5Tsox+2u-DjL3zChhfWBf77Y1@mail.gmail.com
обсуждение исходный текст
Ответы Re: log_checkpoints and restartpoint  (Simon Riggs <simon@2ndQuadrant.com>)
Re: log_checkpoints and restartpoint  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
Hi,

When log_checkpoints is enabled, checkpoint logs the number of
WAL files created/deleted/recycled, but restartpoint doesn't.
This is OK before 9.0 because restartpoint had never created/
deleted/recycled WAL files. But, in 9.0 or later, restartpoint might
do that while walreceiver is running. So I think that it's useful to
log those numbers even in restartpoint in the now.

The attached patch changes LogCheckpointEnd so that it logs
the number of WAL files created/deleted/recycled even in
restartpoint.

And I found the problem about the initialization of CheckpointStats
struct. The attached patch also fixes this.

Comments?

Regards,

--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center

Вложения

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

Предыдущее
От: Steve Singer
Дата:
Сообщение: Re: pl/python SPI in subtransactions
Следующее
От: Itagaki Takahiro
Дата:
Сообщение: Re: REVIEW: WIP: plpgsql - foreach in