The relation between "checkpoint_timeout" and "checkpoint_warning" is missing

Поиск
Список
Период
Сортировка
От Tianyin Xu
Тема The relation between "checkpoint_timeout" and "checkpoint_warning" is missing
Дата
Msg-id CABBDWwfVg275EjUd0daBN7Vd9yaCZewSgbzd3_8ciEXY5XK0tQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: The relation between "checkpoint_timeout" and "checkpoint_warning" is missing  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-docs
Дерево обсуждения
Hi, PG,

In "18.5.2. Checkpoints" (http://www.postgresql.org/docs/9.2/static/runtime-config-wal.html#RUNTIME-CONFIG-WAL-CHECKPOINTS), the relation between "checkpoint_timeout" and "checkpoint_warning" is missing. 

According to the code, "checkpoint_timeout" should be set larger than "checkpoint_warning", otherwise the warnings will not be generated. The comments in function: CheckpointerMain() also tell such behavior, which is in line#473 in "src/backend/postmaster/checkpointer.c":

/*
 * We will warn if (a) too soon since last checkpoint (whatever
 * caused it) and (b) somebody set the CHECKPOINT_CAUSE_XLOG flag
 * since the last checkpoint start.  Note in particular that this
 * implementation will not generate warnings caused by
 * CheckPointTimeout < CheckPointWarning.
 */

I think this's should definitely specified in the documentation.

Best,
Tianyin 

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

Предыдущее
От: Magnus Hagander
Дата:
Сообщение: Re: source download link in installation instructions
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: doc page: ALTER VIEW