|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|
|Views:||Raw Message | Whole Thread | Download mbox | Resend email|
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
> > 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
|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?|
|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|