Re: checkpoints, proper config

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: checkpoints, proper config
Дата
Msg-id 20151210224541.GQ2763@alvherre.pgsql
обсуждение исходный текст
Ответ на Re: checkpoints, proper config  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Ответы Re: checkpoints, proper config  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Список pgsql-performance
Tomas Vondra wrote:

> Also, I don't think it makes much sense to set
>
>    (checkpoint_warning > checkpoint_timeout)
>
> as it kinda defeats the whole purpose of the warning.

I agree, but actually, what is the sense of checkpoint_warning?  I think
it was useful back when we didn't have log_checkpoints, but now that we
have detailed checkpoint logging I think it's pretty much useless noise.

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


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

Предыдущее
От: Tomas Vondra
Дата:
Сообщение: Re: checkpoints, proper config
Следующее
От: Tomas Vondra
Дата:
Сообщение: Re: checkpoints, proper config