TimescaleDB vs ClickHouse
(Timescale co-founder)<p>I&#x27;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&#x27;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&#x27;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&#x27;ve asked Pradeep to compare using the TSBS - and he said he&#x27;d look into it. [2]<p>As a developer, I&#x27;m very wary of technologies that claim to be better at everything - especially those who hide their weaknesses. We don&#x27;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&#x27;m also tired of all the negativity that&#x27;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 &quot;Assume Positive Intent.&quot; [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:&#x2F;&#x2F;blog.timescale.com&#x2F;blog&#x2F;what-is-clickhouse-how-does-it-compare-to-postgresql-and-timescaledb-and-how-does-it-perform-for-time-series-data&#x2F;" rel="nofollow">https:&#x2F;&#x2F;blog.timescale.com&#x2F;blog&#x2F;what-is-clickhouse-how-does-...</a><p>[1] <a href="https:&#x2F;&#x2F;github.com&#x2F;timescale&#x2F;tsbs" rel="nofollow">https:&#x2F;&#x2F;github.com&#x2F;timescale&#x2F;tsbs</a><p>[2] <a href="https:&#x2F;&#x2F;twitter.com&#x2F;p_chhetri&#x2F;status&#x2F;1455216425807745025" rel="nofollow">https:&#x2F;&#x2F;twitter.com&#x2F;p_chhetri&#x2F;status&#x2F;1455216425807745025</a><p>[3] <a href="https:&#x2F;&#x2F;www.timescale.com&#x2F;careers" rel="nofollow">https:&#x2F;&#x2F;www.timescale.com&#x2F;careers</a>