3 ms·
I work for Altinity, which offers commercial support for ClickHouse. We like benchmarks. :) We use the DTC airline on time performance dataset (https://www.t
by hodgesrm 8y ago
I work for Altinity, which offers commercial support for ClickHouse. We like benchmarks. :)
We use the DTC airline on time performance dataset (https://www.transtats.bts.gov/tables.asp?DB_ID=120 https://www.transtats.bts.gov/tables.asp?DB_ID=120) and Yellow Taxi trip data from NYC Open Data (https://data.cityofnewyork.us/browse?q=yellow%20taxi%20data&sortBy=relevance https://data.cityofnewyork.us/browse?q=yellow%20taxi%20data&...) for benchmarking real-time query performance on ClickHouse. I'm working on publishing both datasets in a form that makes it easy to load them quickly. Queries are an exercise for the reader but see Mark Litwintschik's blog for good examples of queries: https://tech.marksblogg.com/billion-nyc-taxi-clickhouse.html https://tech.marksblogg.com/billion-nyc-taxi-clickhouse.html.
We've also done head-to-head comparisons on time series using the TSBS benchmark developed by the Timescale team. See https://www.altinity.com/blog/clickhouse-timeseries-scalability-benchmarks https://www.altinity.com/blog/clickhouse-timeseries-scalabil... for a description of our tests as well as a link to the TSBS Github project.
- einpoklum 8y agoOn an unrelated note: Oh, if you guys are using the OnTime data, have a look at this: https://github.com/eyalroz/usdt-ontime-tools https://github.com/eyalroz/usdt-ontime-tools