Re: checkpoints, proper config

Поиск
Список
Период
Сортировка
Искать
От
Alvaro Herrera
Тема
Re: checkpoints, proper config
Дата
Msg-id
20151210224541.GQ2763@alvherre.pgsql
Ответ на
Список
Дерево обсуждения
checkpoints, proper config Tory M Blue <tmblue@gmail.com>
Re: checkpoints, proper config "Joshua D. Drake" <jd@commandprompt.com>
Re: checkpoints, proper config Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: checkpoints, proper config Alvaro Herrera <alvherre@2ndquadrant.com>
Re: checkpoints, proper config Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: checkpoints, proper config Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: checkpoints, proper config Tory M Blue <tmblue@gmail.com>
Re: checkpoints, proper config "Joshua D. Drake" <jd@commandprompt.com>
Re: checkpoints, proper config Tory M Blue <tmblue@gmail.com>
Re: checkpoints, proper config "Joshua D. Drake" <jd@commandprompt.com>
Re: checkpoints, proper config Jim Nasby <Jim.Nasby@BlueTreble.com>
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
FAQ