Re: PATCH: regular logging of checkpoint progress

Поиск
Список
Период
Сортировка
От Tomas Vondra
Тема Re: PATCH: regular logging of checkpoint progress
Дата
Msg-id 43658c684e9388daf2f8481899571e54.squirrel@sq.gransy.com
обсуждение исходный текст
Ответ на Re: PATCH: regular logging of checkpoint progress  (Peter Eisentraut <peter_e@gmx.net>)
Ответы Re: PATCH: regular logging of checkpoint progress
Re: PATCH: regular logging of checkpoint progress
Re: PATCH: regular logging of checkpoint progress
Список pgsql-hackers
On 2 Září 2011, 15:44, Peter Eisentraut wrote:
> On fre, 2011-09-02 at 11:01 +0200, Tomas Vondra wrote:
>> What about logging it with a lower level, e.g. NOTICE instead of the
>> current LOG? If that's not a solution then a new GUC is needed I
>> guess.
>
> Changing the log level is not the appropriate solution.  Make it a
> configuration parameter.

Why is it inappropriate solution? There's a log_checkpoints GUC that
drives it and you can either get basic info (summary of the checkpoint) or
detailed log (with a lower log level).

In the first patch I've proposed a new GUC (used to set how often the info
should be logged or disable it), but Josh Berkus pointed out that I should
get rid of it if I can. Which is what I've done in the following patches.

Tomas



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

Предыдущее
От: Dimitri Fontaine
Дата:
Сообщение: Re: postgresql.conf archive_command example
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: pg_restore --no-post-data and --post-data-only