From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
---|---|
To: | Bruce Momjian <bruce(at)momjian(dot)us> |
Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Changing checkpoint_timeout to another name? |
Date: | 2007-05-31 23:04:31 |
Message-ID: | 465F547F.9050904@commandprompt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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/
From | Date | Subject | |
---|---|---|---|
Next Message | ITAGAKI Takahiro | 2007-06-01 01:08:27 | Re: Autovacuum versus rolled-back transactions |
Previous Message | Alvaro Herrera | 2007-05-31 21:32:17 | Re: Autovacuum versus rolled-back transactions |