Pushing the PostgreSQL Limits in a 1TB TPC-H Lab Exercise
24 November
How fast can classical PostgreSQL really go on analytical workloads? Using the TPC-H query stream on a 1TB database, this session walks through the journey from a default-configured HammerDB test schema to almost 10x faster processing time. CPU resources, memory, high-performance I/O, and proper GUC parameters were the necessary prerequisites - but that was only the point where the real journey began.
The presentation covers the key performance decisions - on the database server side and in the schema design - all within TPC-H specification requirements, and in particular without changing the query text.
This is also a journey of changing perception: the goal is to show how PostgreSQL can leverage the platform's capabilities, and which lessons carry over to more general use cases - touching on areas where common understanding may need some refinement, such as database statistics and indexing.