Re: [DOCS] "distributed checkpoint" - Mailing list pgsql-hackers

From Jonah H. Harris
Subject Re: [DOCS] "distributed checkpoint"
Date
Msg-id 36e682920712071950x522646edub34cab934aa4396e@mail.gmail.com
Whole thread Raw
In response to Re: [DOCS] "distributed checkpoint"  (Greg Smith <gsmith@gregsmith.com>)
List pgsql-hackers
On Dec 7, 2007 10:25 PM, Greg Smith <gsmith@gregsmith.com> wrote:
> > "Smoothed" makes a lot of sense for me. We used to have a checkpoint
> > spike, now we don't.
>
> To be accurate, there used to be a huge and unavoidable spike, now there's
> a control that aims to make it smaller.  The problem hasn't completely
> gone away yet.

Agreed.

> "Distributed checkpoints prevent I/O spikes during checkpoints"
>
> It's good this came up, because that is factually wrong;

Agreed.

> "Checkpoint writes can be spread over a longer time period to smooth the
> I/O spike during each checkpoint"

Sounds good to me.

> It's got spread, it's got smooth, and if I could have worked "silky" in
> there too I would have.

:)

-- 
Jonah H. Harris, Sr. Software Architect | phone: 732.331.1324
EnterpriseDB Corporation                | fax: 732.331.1301
499 Thornall Street, 2nd Floor          | jonah.harris@enterprisedb.com
Edison, NJ 08837                        | http://www.enterprisedb.com/


pgsql-hackers by date:

Previous
From: Greg Smith
Date:
Subject: Re: [DOCS] "distributed checkpoint"
Next
From: Gregory Stark
Date:
Subject: Re: pg_controldata doesn't report 64/32bit?