You wait a lifetime for an Ingres TPC benchmark and then three come along together…

Share

london-busesEarlier this year I blogged about how after tap dancing around the issue of TPC benchmarks for decades we’d finally published our first TPC-H benchmark results at the 100 scale.  Earlier today we announced that we had broken two TPC-H records across 300GB and 1TB data sets running VectorWise on a Dell PowerEdge R910 server with Red Hat Enterprise Linux 6.0.

Details of the 300GB Benchmark

The VectorWise and Dell 300GB benchmark delivered 330% of the previous best single-node performance; an astonishing increase of 230%, with 400,931.8 QphH@300GB, versus the previous high of 121,345.6 QphH@300GB. Price for performance came in at US$0.35/QphH@300GB versus the previous best of US$0.65/QphH@300GB, thereby reducing the cost of performance by 46% (i).

Details of the 1TB Benchmark

The 1TB benchmark delivered an astonishing 251% of the previous best single-node performance; a 151% increase, with performance of 436,788.9 QphH@1TB versus the previous high of 173,961.8 QphH@1TB. The price for performance came in at US$0.88/QphH@1TB, 36% less than the previous best price for performance at US$1.37/QphH@1TB (ii).

For more details about our results I’d encourage you to visit the TPC website.

(i) Top two non-clustered 300GB TPC-H results as of 5/4/11: Dell PowerEdge R910, availability 6/30/11 at a total  system cost of USD $139,459 , compared to HP ProLiant DL580 G7 running Microsoft SQL Server 2008 R2 Enterprise Edition on Microsoft Windows Server 2008 R2 Enterprise Edition, availability 9/14/10 at a total system cost of USD $78,687.

(ii) Top two non-clustered 1TB TPC-H results as of 5/4/11: Dell PowerEdge R910, availability 6/30/11 at a total system cost of USD $384,935compared to IBM System x3850 X5 running Microsoft SQL Server 2008 R2 Enterprise Edition on Microsoft Windows Server 2008 R2 Enterprise Edition, availability 5/20/11 at a total system cost of USD $238,375.

About Emma McGrattan

As SVP of Engineering at Actian, Emma leads development for the Actian Vector team, including the Ingres and X100 components, and the Actian Matrix Planner team. A leading authority in DBMS technologies, Emma is celebrating 20 years in Ingres and Actian Engineering.

View all posts by Emma McGrattan →

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>