| From: | Tianyin Xu <tixu(at)cs(dot)ucsd(dot)edu> |
|---|---|
| To: | pgsql-docs(at)postgresql(dot)org |
| Subject: | The relation between "checkpoint_timeout" and "checkpoint_warning" is missing |
| Date: | 2013-02-08 09:38:09 |
| Message-ID: | CABBDWwfVg275EjUd0daBN7Vd9yaCZewSgbzd3_8ciEXY5XK0tQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
--
Tianyin XU,
http://cseweb.ucsd.edu/~tixu/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2013-02-09 13:31:55 | Re: doc page: ALTER VIEW |
| Previous Message | Magnus Hagander | 2013-02-05 06:44:16 | Re: source download link in installation instructions |