Difference between revisions of "TPC-H"

From PostgreSQL wiki
Jump to: navigation, search
(Change broken links to archive.org, add Jignesh's talk)
 
Line 3: Line 3:
 
Notes:
 
Notes:
 
* [http://dsl.serc.iisc.ernet.in/projects/PICASSO/picasso_download/doc/Installation/tpch.htm TPC-H data generation and loading]
 
* [http://dsl.serc.iisc.ernet.in/projects/PICASSO/picasso_download/doc/Installation/tpch.htm TPC-H data generation and loading]
* [http://monetdb.cwi.nl/SQL/Benchmark/TPCH/ TPC-H Performance Study] using an old version of PostgreSQL
+
* [https://web.archive.org/web/20110406233644/http://monetdb.cwi.nl/SQL/Benchmark/TPCH/ TPC-H Performance Study] using an old version of PostgreSQL
 
* [http://archives.postgresql.org/pgsql-hackers/2010-01/msg01867.php Discussion of limitations] started by the above
 
* [http://archives.postgresql.org/pgsql-hackers/2010-01/msg01867.php Discussion of limitations] started by the above
 
* [http://m.tholis.webnode.com/news/tpc-h-fun-with-greenplum-single-node-edition-/ TPC-H fun with Greenplum (single node edition)] - leads into the below and discusses what's needed to do well on TPC-H
 
* [http://m.tholis.webnode.com/news/tpc-h-fun-with-greenplum-single-node-edition-/ TPC-H fun with Greenplum (single node edition)] - leads into the below and discusses what's needed to do well on TPC-H
* [http://community.greenplum.com/showthread.php?t=113  GP SNE versus Postgres 8.4.2 - 22 Query Benchmark Results] (similar to TPC-H queries, tweaked to run better)
+
* [https://web.archive.org/web/20100212084437/http://community.greenplum.com/showthread.php?t=113  GP SNE versus Postgres 8.4.2 - 22 Query Benchmark Results] (similar to TPC-H queries, tweaked to run better)
 
[[Category:Benchmarking]]
 
[[Category:Benchmarking]]
 +
* [http://www.slideshare.net/jkshah/postgresql-and-benchmarks PostgreSQL and Benchmarks] TPC-H, TPC-E, and EAStress 2004 review (2008)

Latest revision as of 21:56, 15 April 2016

The TPC-H Benchmark is a popular one for comparing database vendors. It's possible to run the TPC-H data set on PostgreSQL without having a formal testing kit (although there is DBT-3, a work in progress to provide a full kit). The results have generally been disappointing, for reasons that aren't necessarily relevant in the real world. PostgreSQL is missing some of the things needed to do well on this benchmark, whereas proprietary database vendors are so focused on it they will "game" TPC-H runs (add optimizations specifically aimed at it) to make absolutely sure they do well.

Notes: