Changing checkpoint_timeout to another name?
Hello,
I am currently writing some curriculum on managing IO with PostgreSQL
and I keep running into the parameter checkpolint_timeout. This seems to
be incorrect as it is not really a timeout as much as an interval...
Thoughts?
Sincerely,
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
http://www.commandprompt.com/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/
Joshua D. Drake wrote:
Hello,
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...
Thoughts?
Sincerely,
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
http://www.commandprompt.com/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/
Joshua D. Drake wrote:
Joshua D. Drake wrote:
Hello,
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?
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
Bruce Momjian wrote:
Joshua D. Drake wrote:
Joshua D. Drake wrote:
Hello,
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
http://www.commandprompt.com/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/