Re: [PATCHES] Load Distributed Checkpoints, revised patch

From: "Simon Riggs" <simon(at)2ndquadrant(dot)com>
To: "Michael Paesold" <mpaesold(at)gmx(dot)at>
Cc: "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>, "Patches" <pgsql-patches(at)postgresql(dot)org>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [PATCHES] Load Distributed Checkpoints, revised patch
Date: 2007-06-16 09:14:46
Message-ID: 1181985286.17734.72.camel@silverbirch.site
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

On Fri, 2007-06-15 at 13:11 +0200, Michael Paesold wrote:
> Heikki Linnakangas wrote:
> > Here's an updated WIP version of the LDC patch. I just spreads the
> > writes, that achieves the goal of smoothing the checkpoint I/O spikes. I
> > think sorting the writes etc. is interesting but falls in the category
> > of further development and should be pushed to 8.4.
>
> Why do you think so? Is it too much risk to adapt the sorted writes? The
> numbers shown by ITAGAKI Takahiro looked quite impressive, at least for
> large shared_buffers configurations. The reactions where rather
> positive, too.

Agreed.

Seems like a simple isolated piece of code to include or not. If we
controlled it with a simple boolean parameter, that would allow testing
during beta - I agree it needs more testing.

If we find a way of automating it, cool. If its flaky, strip it out
before we release.

--
Simon Riggs
EnterpriseDB http://www.enterprisedb.com

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2007-06-16 14:56:24 Re: Maintaining cluster order on insert
Previous Message Simon Riggs 2007-06-16 09:10:16 Re: Load Distributed Checkpoints, revised patch

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2007-06-16 14:56:24 Re: Maintaining cluster order on insert
Previous Message Simon Riggs 2007-06-16 09:10:16 Re: Load Distributed Checkpoints, revised patch