Re: Benchmarks WAS: Sun Talks about MySQL - Mailing list pgsql-performance

From Josh Berkus
Subject Re: Benchmarks WAS: Sun Talks about MySQL
Date
Msg-id 4815F648.9050901@agliodbs.com
Whole thread Raw
In response to Re: [pgsql-advocacy] Benchmarks WAS: Sun Talks about MySQL  (Gregory Stark <stark@enterprisedb.com>)
Responses Re: Benchmarks WAS: Sun Talks about MySQL
List pgsql-performance
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.

--Josh

pgsql-performance by date:

Previous
From: "A B"
Date:
Subject: Where do a novice do to make it run faster?
Next
From: Gaetano Mendola
Date:
Subject: shared_buffer/DRBD performances