From: Gregory Stark <stark@enterprisedb.com>
To: Josh Berkus <josh@agliodbs.com>
Cc: pgsql-hackers@postgresql.org
Cc: Markus Schiltknecht <markus@bluegap.ch>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Subject: Re: WIP patch for latestCompletedXid method of computing snapshot xmax
Date: Sat, 08 Sep 2007 22:51:18 +0100
Message-ID: <87myvwx1ux.fsf@oxford.xeocode.com> (raw)
In-Reply-To: <200709081418.35059.josh@agliodbs.com>
References: <3018.1189214811@sss.pgh.pa.us>
<28198.1189282917@sss.pgh.pa.us>
<46E30EB4.7020304@bluegap.ch>
<200709081418.35059.josh@agliodbs.com>
"Josh Berkus" <josh@agliodbs.com> writes:
> Hmmm. Your results are withing the margin of error for DBT2, so they show no
> real difference. What we need for this is a heavy-read workload, though; on
> a workload like DBT2 (which is mostly writes) I wouldn't expect lazy-XID to
> help much.
The TPM is definitely within the margin of error but the 90th percentile
response times seem worrisome. But they're already over 5s which are TPC-C
failures. From what we've seen when you push the scale factor too high until
those numbers are even close to 5s you get very unstable results.
The published benchmarks seem to keep the max around 5s which puts the 90th
percentile around half that. That seems overly conservative but I wonder what
reason they have for doing it that way.
> I'll see if I can find something appropriate. Maybe Jan's TPC-W
> implementation?
We could just rejigger the percentages on the transactions. I think Stock
Level and Order Status are entirely read-only but I would have to check. Stock
Level is a very intensive query though so I wouldn't suggest raising the
percentage on that.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: stark@enterprisedb.com, josh@agliodbs.com, markus@bluegap.ch, tgl@sss.pgh.pa.us
Subject: Re: WIP patch for latestCompletedXid method of computing snapshot xmax
In-Reply-To: <87myvwx1ux.fsf@oxford.xeocode.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox