From: Gregory Stark <stark@enterprisedb.com>
To: Josh Berkus <josh@agliodbs.com>
Cc: Euler Taveira de Oliveira <euler@timbira.com>
Cc: Greg Smith <gsmith@gregsmith.com>
Cc: postgres performance list <pgsql-performance@postgresql.org>
Subject: Re: Benchmarks WAS: Sun Talks about MySQL
Date: Mon, 28 Apr 2008 14:40:25 -0400
Message-ID: <873ap5akme.fsf@oxford.xeocode.com> (raw)
In-Reply-To: <4815F648.9050901@agliodbs.com>
References: <480F8C2D.6010806@emproshunts.com>
<4811D1DD.9030401@otg-nc.com>
<20080425130105.GA19447@crankycanuck.ca>
<36e682920804250741p33d621f3gf35e6bdebe2e0531@mail.gmail.com>
<20080425152053.GE19447@crankycanuck.ca>
<Pine.GSO.4.64.0804251942060.28069@westnet.com>
<481278E7.9030504@timbira.com>
<87wsmlm90e.fsf@oxford.xeocode.com>
<4814BDB8.2030108@agliodbs.com>
<877iei9w4r.fsf@oxford.xeocode.com>
<4815F648.9050901@agliodbs.com>
"Josh Berkus" <josh@agliodbs.com> writes:
> Greg,
>
>> What I was referring to by "passing" TPC-E was the criteria for a conformant
>> benchmark run. TPC-C has iirc, only two relevant criteria: "95th percentile
>> response time < 5s" and "average response time < 95th percentile response
>> time". You can pass those even if 1 transaction in 20 takes 10-20s which is
>> more than enough to cover checkpoints and other random sources of inconsistent
>> performance.
>
> We can do this now. I'm unhappy because we're at about 1/4 of Oracle
> performance, but we certainly pass -- even with 8.2.
We certainly can pass TPC-C. I'm curious what you mean by 1/4 though? On
similar hardware? Or the maximum we can scale to is 1/4 as large as Oracle?
Can you point me to the actual benchmark runs you're referring to?
But I just made an off-hand comment that I doubt 8.2 could pass TPC-E which
has much more stringent requirements. It has requirements like:
the throughput computed over any period of one hour, sliding over the Steady
State by increments of ten minutes, varies from the Reported Throughput by no
more than 2%
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's Slony Replication support!
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-performance@postgresql.org
Cc: stark@enterprisedb.com, josh@agliodbs.com, euler@timbira.com, gsmith@gregsmith.com
Subject: Re: Benchmarks WAS: Sun Talks about MySQL
In-Reply-To: <873ap5akme.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