Re: Sorting writes during checkpoint - Mailing list pgsql-patches

From Simon Riggs
Subject Re: Sorting writes during checkpoint
Date
Msg-id 1215673572.4051.1198.camel@ebony.2ndQuadrant
Whole thread Raw
In response to Re: Sorting writes during checkpoint  (Greg Smith <gsmith@gregsmith.com>)
List pgsql-patches
On Wed, 2008-07-09 at 21:39 -0400, Greg Smith wrote:
> On Fri, 4 Jul 2008, Simon Riggs wrote:
>
> > No action on this seen since last commitfest, but I think we should
> do
> > something with it, rather than just ignore it.
>
> Just no action worth reporting yet.  Over the weekend I finally
> reached the point where I've got a system that should be capable of
> independently replicating the results improvement setup here, and I've
> started performance testing of the patch.  Getting useful checkpoint
> test results from pgbench is really a pain.

I agree completely. That's why I've suggested a plugin approach. That
way Itagaki can have his performance, the rest of us don't need to fret
and yet we hold open the door indefinitely for additional ways of doing
it. And we can test it on production systems with realistic workloads.
If one clear way emerges as best, we adopt that plugin permanently.

--
 Simon Riggs           www.2ndQuadrant.com
 PostgreSQL Training, Services and Support


pgsql-patches by date:

Previous
From: Greg Smith
Date:
Subject: Re: Sorting writes during checkpoint
Next
From: "Pavel Stehule"
Date:
Subject: Re: review: table function support