Re: Sorting writes during checkpoint

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: Greg Smith <gsmith(at)gregsmith(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>, pgsql-patches(at)postgresql(dot)org
Subject: Re: Sorting writes during checkpoint
Date: 2008-07-10 07:06:12
Message-ID: 1215673572.4051.1198.camel@ebony.2ndQuadrant
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers 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
PostgreSQL Training, Services and Support

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Stuart Gundry 2008-07-10 08:37:42 Re: Security and Data Protection Issues
Previous Message Stephen R. van den Berg 2008-07-10 05:54:17 Re: Protocol 3, Execute, maxrows to return, impact?

Browse pgsql-patches by date

  From Date Subject
Next Message Pavel Stehule 2008-07-10 08:58:18 Re: review: table function support
Previous Message Abhijit Menon-Sen 2008-07-10 03:11:40 Re: Extending grant insert on tables to sequences