public inbox for [email protected]
help / color / mirror / Atom feedThe relation between "checkpoint_timeout" and "checkpoint_warning" is missing
2+ messages / 2 participants
[nested] [flat]
* The relation between "checkpoint_timeout" and "checkpoint_warning" is missing
@ 2013-02-08 09:38 Tianyin Xu <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: Tianyin Xu @ 2013-02-08 09:38 UTC (permalink / raw)
To: 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/
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: The relation between "checkpoint_timeout" and "checkpoint_warning" is missing
@ 2013-03-10 21:17 Peter Eisentraut <[email protected]>
parent: Tianyin Xu <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: Peter Eisentraut @ 2013-03-10 21:17 UTC (permalink / raw)
To: Tianyin Xu <[email protected]>; +Cc: pgsql-docs
On Fri, 2013-02-08 at 01:38 -0800, Tianyin Xu wrote:
> 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.
Fixed. Thanks for the suggestion.
--
Sent via pgsql-docs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2013-03-10 21:17 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2013-02-08 09:38 The relation between "checkpoint_timeout" and "checkpoint_warning" is missing Tianyin Xu <[email protected]>
2013-03-10 21:17 ` Peter Eisentraut <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox