TPC-H

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:

• TPC-H data generation and loading
• TPC-H Performance Study using an old version of PostgreSQL
• Discussion of limitations started by the above
• TPC-H fun with Greenplum (single node edition) - leads into the below and discusses what's needed to do well on TPC-H
• GP SNE versus Postgres 8.4.2 - 22 Query Benchmark Results (similar to TPC-H queries, tweaked to run better)
• PostgreSQL and Benchmarks TPC-H, TPC-E, and EAStress 2004 review (2008)