You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
@alexey-milovidov This benchmark is based on the result from TSM-Bench repository, they used InfluxDB 1.7 to make benchmarks against Clickhouse. There are 3 mainstream versions of InfluxDB:
InfluxDB 1 - The latest version is 1.8, and it is written in Go
InfluxDB 2 - The rewritten version of InfluxDB 1, and it is written in Rust. Though it is open source, the official helm chart is somehow using InfluxDB 1.8 as of now (December 2023)
InfluxDB 3 - This one is closed source as of now (December 2023). They also claimed InfluxDB 3 is 45x faster than InfluxDB 1.8.
Activity
alexey-milovidov commentedon Mar 31, 2021
ClickHouse vs Elasticsearch: https://my.oschina.net/taogang/blog/4965018
alexey-milovidov commentedon Mar 31, 2021
Brown university: https://github.com/crottyan/mgbench
Abandoned, but still quite fresh.
alexey-milovidov commentedon Mar 31, 2021
CERN ClickHouse vs InfluxDB: http://cds.cern.ch/record/2667383/
alexey-milovidov commentedon Apr 1, 2021
https://fivetran.com/blog/warehouse-benchmark (without ClickHouse)
alexey-milovidov commentedon Apr 1, 2021
h2o.ai dataframe like benchmark: https://h2oai.github.io/db-benchmark/
alexey-milovidov commentedon Apr 1, 2021
AMPLab benchmark: https://amplab.cs.berkeley.edu/benchmark/
Outdated and abandoned, does not include ClickHouse.
alexey-milovidov commentedon Apr 1, 2021
TSBS benchmark: https://altinity.com/blog/clickhouse-for-time-series
(2018 version, does not have read in order optimization)
ClickHouse vs Kudu on TSBS (from Cloudera, in favor of Kudu):
https://blog.cloudera.com/benchmarking-time-series-workloads-on-apache-kudu-using-tsbs/
alexey-milovidov commentedon Apr 1, 2021
ClickHouse vs Spark on Wikipedia data:
https://www.percona.com/blog/2017/02/13/clickhouse-new-opensource-columnar-database/
alexey-milovidov commentedon Apr 1, 2021
ClickHouse vs. MariaDB ColumnStore on Star Schema Benchmark (TPC-H derivative):
https://www.percona.com/blog/2020/07/27/clickhouse-and-columnstore-in-the-star-schema-benchmark/
alexey-milovidov commentedon Apr 1, 2021
ClickHouse vs. Redshift on NYC taxi dataset:
https://altinitydb.medium.com/clickhouse-vs-amazon-redshift-benchmark-e223429f4f95
alexey-milovidov commentedon Apr 1, 2021
ClickHouse vs. Redshift (price-performance), no many details:
https://altinity.com/blog/2017/7/3/clickhouse-vs-redshift-2
alexey-milovidov commentedon Apr 1, 2021
PostgreSQL vs ClickHouse via clickhouse_fdw in PostgreSQL:
https://www.percona.com/blog/2019/05/09/improving-olap-workload-performance-for-postgresql-with-clickhouse-database/
alexey-milovidov commentedon Apr 1, 2021
ClickHouse vs. MariaDB Column Store vs. Spark vs. MySQL on Wikipedia data:
https://www.percona.com/blog/2017/03/17/column-store-database-benchmarks-mariadb-columnstore-vs-clickhouse-vs-apache-spark/
alexey-milovidov commentedon Apr 1, 2021
ClickHouse vs. clickhouse_fdw in PostgreSQL:
https://www.percona.com/blog/2019/05/01/benchmark-clickhouse-database-and-clickhousedb_fdw/
58 remaining items
alexey-milovidov commentedon Dec 18, 2023
ClickHouse, TimescaleDB, QuestDB, InfluxDB, eXtremeDB:
https://www.mcobject.com/wp-content/uploads/dlm_uploads/2023/08/TSM-Bench-Benchmarking-Time-Series-Database-Systems.pdf
joeky888 commentedon Dec 18, 2023
@alexey-milovidov This benchmark is based on the result from TSM-Bench repository, they used InfluxDB 1.7 to make benchmarks against Clickhouse. There are 3 mainstream versions of InfluxDB:
alexey-milovidov commentedon Apr 27, 2024
https://www.timestored.com/data/time-series-database-benchmarks
rschu1ze commentedon May 3, 2025
https://rtabench.com
MacNale commentedon Oct 15, 2025
https://ar5iv.labs.arxiv.org/html/2301.12561
alexey-milovidov commentedon Oct 31, 2025
Real-time analytics benchmark: https://github.com/toddstoffel/analytics_benchmark
inv2004 commentedon Nov 27, 2025
https://kx.com/blog/benchmarking-kdb-x-vs-questdb-clickhouse-timescaledb-and-influxdb-with-tsbs/
ramazanpolat commentedon Nov 27, 2025
https://www.velodb.io/blog/apache-doris-34x-faster-clickhouse-realtime-updates
ramazanpolat commentedon Nov 27, 2025
The Ultimate OLAP Showdown: Apache Doris vs. ClickHouse vs. Snowflake (Part 1):
https://www.velodb.io/blog/ultimate-olap-showdown-apache-doris-clickhouse-snowflake
Apache Doris Up To 40x Faster Than ClickHouse | OLAP Showdown Part 2:
https://www.velodb.io/blog/apache-doris-40x-faster-clickhouse-tpc-ds
alexey-milovidov commentedon Jun 22, 2026
SQL Mandelbrot Benchmark: https://github.com/ClickHouse/sql-mandelbrot-benchmark
alexey-milovidov commentedon Aug 29, 2026
ClickHouse vs Snowflake, including Snowflake Interactive, Clustered, Search Optimized, and Postgres:
https://medium.com/manychat-engineering/sub-second-on-a-billion-rows-which-warehouse-actually-keeps-up-6f4bd708b841