should we enable log_checkpoints out of the box?

Поиск
Список
Период
Сортировка
От Bharath Rupireddy
Тема should we enable log_checkpoints out of the box?
Дата
Msg-id CALj2ACX-rW_OeDcp4gqrFUAkf1f50Fnh138dmkd0JkvCNQRKGA@mail.gmail.com
обсуждение исходный текст
Ответы Re: should we enable log_checkpoints out of the box?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Hi,

It seems the checkpoint stats, that are emitted to server logs when
the GUC log_checkpoints is enabled, are so important that a postgres
database provider would ever want to disable the GUC. Right now, the
GUC is disabled by default and a postgres database provider needs to
enable it explicitly. How about we
enable it out of the box? One disadvantage is that it may fill up the
server logs if the checkpoints are so frequent. However the
checkpoints stats are captured even when the GUC is disabled [1].

Thoughts?

[1]
    /*
     * Prepare to accumulate statistics.
     *
     * Note: because it is possible for log_checkpoints to change while a
     * checkpoint proceeds, we always accumulate stats, even if
     * log_checkpoints is currently off.
     */
    MemSet(&CheckpointStats, 0, sizeof(CheckpointStats));

Regards,
Bharath Rupireddy.



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

Предыдущее
От: Bharath Rupireddy
Дата:
Сообщение: emit recovery stats via a new file or a new hook
Следующее
От: Tom Lane
Дата:
Сообщение: Re: should we enable log_checkpoints out of the box?