Lists: | pgsql-hackers |
---|
From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
---|---|
To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Changing checkpoint_timeout to another name? |
Date: | 2007-05-30 18:48:55 |
Message-ID: | 465DC717.2060206@commandprompt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
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/
From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
---|---|
To: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Changing checkpoint_timeout to another name? |
Date: | 2007-05-30 18:54:14 |
Message-ID: | 465DC856.5030602@commandprompt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
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/
From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Changing checkpoint_timeout to another name? |
Date: | 2007-05-30 19:02:55 |
Message-ID: | 200705301902.l4UJ2ts24545@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
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(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
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 |
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/