This includes a combination of three benchmarks: MgBench, Star Schema Benchmark, New York Taxi Rides Benchmark and ClickBench.
Hardware used to run tests: x86_64 AWS m5.8xlarge Ubuntu 20.04.
In 23.7 sparse columns feature is enabled by default. Tables were populated again to utilize sparse columns.
Old versions had no support of these features/syntax: toISOWeek, SUBSTRING, EXTRACT, WITH. Queries were changed. All version runs use same queries.
Star Schema Benchmark Patrick O'Neil, Elizabeth (Betty) O'Neil and Xuedong Chen. "The Star Schema Benchmark," Online Publication of Database Generation program., January 2007. http://www.cs.umb.edu/~poneil/StarSchemaB.pdf
This includes a combination of three benchmarks: MgBench, Star Schema Benchmark, New York Taxi Rides Benchmark and ClickBench.
Hardware used to run tests: x86_64 AWS m5.8xlarge Ubuntu 20.04.
In 23.7 sparse columns feature is enabled by default. Tables were populated again to utilize sparse columns.
Old versions had no support of these features/syntax: toISOWeek, SUBSTRING, EXTRACT, WITH. Queries were changed. All version runs use same queries.
Star Schema Benchmark Patrick O'Neil, Elizabeth (Betty) O'Neil and Xuedong Chen. "The Star Schema Benchmark," Online Publication of Database Generation program., January 2007. http://www.cs.umb.edu/~poneil/StarSchemaB.pdf
Summary of the 1.1 Billion Taxi Rides Benchmarks, Mark Litwintschikhttps://tech.marksblogg.com/benchmarks.html