Bruce Momjian wrote:
Joshua D. Drake wrote:
Joshua D. Drake wrote:

I am currently writing some curriculum on managing IO with PostgreSQL and I keep running into the parameter checkpolint_timeout.
*cough* checkpoint_timeout

  This seems to
be incorrect as it is not really a timeout as much as an interval...

It is a timeout because of WAL fills up before the timeout you get a
checkpoint and the timer is reset.  How is it an interval?

because if it doesn't, it will checkpoint at that timeout which is an interval :). It depends on how you look at it I guess. For me, I try to make sure we are never rolling our logs until checkpoint, so it is an interval.

Joshua D. Drake


      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997

Donate to the PostgreSQL Project:
PostgreSQL Replication:

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply via email to