| From: | Greg Smith <greg(at)2ndquadrant(dot)com> |
|---|---|
| To: | Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec> |
| Cc: | Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: XLogInsert |
| Date: | 2009-12-15 06:16:00 |
| Message-ID: | 4B2729A0.2090807@2ndquadrant.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Jaime Casanova wrote:
> So in this extreme case avg tps is just 6 transactions better
>
Great job trying to find the spot where the code worked better. I'm not
so sure I trust pgbench results where the TPS was so low though. Which
leads us right back to exactly how Jeff measured his original results.
As I said already, I think we need more insight into Jeff's performance
report, a way to replicate that test, to look a bit at the latency as
reported by the updated LWLock patch that Pierre submitted. Tweaking
your test to give more useful results is a nice second opinion on top of
that. But we're out of time for now, so this patch is getting returned
with feedback. I encourage Jeff to resubmit the same patch or a better
one with a little more data on performance measurements to our final 8.5
CommitFest in hopes we can confirm this an improvement worth committing.
--
Greg Smith 2ndQuadrant Baltimore, MD
PostgreSQL Training, Services and Support
greg(at)2ndQuadrant(dot)com www.2ndQuadrant.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Takahiro Itagaki | 2009-12-15 06:23:12 | Re: pgbench: new feature allowing to launch shell commands |
| Previous Message | Greg Smith | 2009-12-15 06:09:55 | Re: pgbench: new feature allowing to launch shell commands |