Re: Should bgwriter log checkpoint start/end?

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: Should bgwriter log checkpoint start/end?
Дата
Msg-id 87pt34rlwb.fsf@stark.xeocode.com
обсуждение исходный текст
Ответ на Re: Should bgwriter log checkpoint start/end?  (Simon Riggs <simon@2ndquadrant.com>)
Список pgsql-hackers
Simon Riggs <simon@2ndquadrant.com> writes:

> For now, DEBUG1. Longer term, we need to discuss a "performance log" or
> some place to put regularly collected performance statistics, rather
> than site specific ones.

As a data point, with Oracle we often found it useful that Oracle logs all
checkpoints. One log entry every few minutes really isn't an excessive amount
of logging, even if it is a routine non-error condition.

I would suggest a higher level, INFO or NOTICE.

-- 
greg



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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: src/timezone/pgtz __imp__my_exec_path
Следующее
От: Tom Lane
Дата:
Сообщение: Re: 8.0b4: COMMIT outside of a transaction echoes ROLLBACK