Re: PATCH: regular logging of checkpoint progress

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: PATCH: regular logging of checkpoint progress
Дата
Msg-id 4E60AC8C0200002500040B2D@gw.wicourts.gov
обсуждение исходный текст
Ответ на Re: PATCH: regular logging of checkpoint progress  ("Tomas Vondra" <tv@fuzzy.cz>)
Список pgsql-hackers
."Tomas Vondra" <tv@fuzzy.cz> wrote:
> On 2 Zá*í 2011, 15:44, Peter Eisentraut wrote:
>> 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).
Maybe?:
log_checkpoints = 'verbose'
It seems to me that one of the most likely uses of this is for
investigating performance issues in production.  Like with
log_statement, you might want to turn it on briefly and examine
results.
-Kevin



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

Предыдущее
От: "Tomas Vondra"
Дата:
Сообщение: Re: PATCH: regular logging of checkpoint progress
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: PATCH: regular logging of checkpoint progress