ClickHouse Versions Benchmark

Source | Report Mistake | Benchmark For Analytical DBMS | Hardware Benchmark
Version: All
Metric: Cold Run Hot Run
version Relative time (lower is better)
Nothing selected

Detailed Comparison

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