Postgres Pro
Downloads
Home   >   mailing lists

Thread: Changing checkpoint_timeout to another name?

Changing checkpoint_timeout to another name?

From
"Joshua D. Drake"
Date:
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/

Re: Changing checkpoint_timeout to another name?

From
"Joshua D. Drake"
Date:
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/

Re: Changing checkpoint_timeout to another name?

From
Bruce Momjian
Date:
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. +

Re: Changing checkpoint_timeout to another name?

From
"Joshua D. Drake"
Date:
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/