Listening to Hannes Muheisen in the Joe Reis podcast, he said at one point that TCP-H benchmarks were “horrible, people should use TPC-DS”. He is the creator of DuckDB (and CEO of the company). He didn’t elaborate.

So, out of curiosity I learned that TPC-DS purpose is to benchmark the performance of systems handling complex decision support workloads, like the ones in data warehouses. And TCP-H focuses on ad-hoc decision support systems. It’s simpler and more about measuring the capability of a database to execute a smaller number of queries. It focuses on single user-query execution and the other one (TCP-DS) supports multi-user environments. There is much more than this, of course. Learn all about it here: TPC-DS