TimescaleDB vs ClickHouse
(Timescale co-founder)<p>I'll answer this here with a similar response that I gave Pradeep (the author) via Twitter.<p>I think ClickHouse is a great technology. It totally beats TimescaleDB for OLAP queries. I'll be the first to admit that.<p>What our (100+ hour, 3 month analysis) benchmark showed is that for _time-series workloads_, TimescaleDB fared better. [0]<p>Pradeep's analysis - while earnest - is essentially comparing OLAP style queries using a dataset that is not very representative of time-series workloads. Which is why the time-series benchmark suite (TSBS) [1] exists (which we did not create, although we now maintain it). I've asked Pradeep to compare using the TSBS - and he said he'd look into it. [2]<p>As a developer, I'm very wary of technologies that claim to be better at everything - especially those who hide their weaknesses. We don't do that at TimescaleDB. For those who read our benchmark closely, we clearly show where ClickHouse beats TimescaleDB, and where TimescaleDB does better. And - despite what many commenters on here may want you to think - we heap loads of praise on ClickHouse.<p>As a reader of HackerNews, I'm also tired of all the negativity that's developing on this site. People who bully. People who default to accusing others of dishonesty instead of trying to have a meaningful dialogue and reach mutual understanding. People who enter debates wanting to be right, versus wanting to identify the right answer. Disappointingly, this includes some visible influencers whom I personally know. We should all strive to do better, to assume positive intent, and have productive dialogues.<p>(This is why one of our values at TimescaleDB is "Assume Positive Intent." [3] I think Hacker News - and the world in general - would be a much better, happier, healthier place if we all just did that.)<p>[0] <a href="https://blog.timescale.com/blog/what-is-clickhouse-how-does-it-compare-to-postgresql-and-timescaledb-and-how-does-it-perform-for-time-series-data/" rel="nofollow">https://blog.timescale.com/blog/what-is-clickhouse-how-does-...</a><p>[1] <a href="https://github.com/timescale/tsbs" rel="nofollow">https://github.com/timescale/tsbs</a><p>[2] <a href="https://twitter.com/p_chhetri/status/1455216425807745025" rel="nofollow">https://twitter.com/p_chhetri/status/1455216425807745025</a><p>[3] <a href="https://www.timescale.com/careers" rel="nofollow">https://www.timescale.com/careers</a>