Topic
Performance engineering
Benchmarking, query performance analysis and performance regression testing, starting from TPC-H on Trino.
Case studies
Articles
Turning a query engine benchmark into a performance regression test
Baselines, noise, run counts, statistical comparison and per-query thresholds for catching Trino performance regressions in CI.
Reading Trino query plans to find bottlenecks in TPC-H derived queries
How to read EXPLAIN and EXPLAIN ANALYZE in Trino, and what fragments, exchanges, join distribution, dynamic filters and statistics tell you.
Measuring Performance Excellence: Trino TPC-H Benchmark, Part 2 (opens Towards Dev in a new tab)
A hands-on walkthrough of setting up Trino, running the TPC-H workload on a test machine and generating an execution report.
Measuring Performance Excellence: TPC-H Benchmark, Part 1 (opens Towards Dev in a new tab)
Why benchmarking matters for data analytics platforms, what the TPC-H workload measures, its 22 queries, and the practical challenges of running it well.
Work with me
Working on a problem like the ones above? I am glad to compare notes.