Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

TimescaleDB vs ClickHouse

pradeepchhetri.xyz

Post reply on HN
Print view View original

71–76 of 76 posts

Re: TimescaleDB vs ClickHouse

#71

Post by TinyCuteGorilla »

ensignavenger wrote: post #68
TinyCuteGorilla wrote: post #63

Earlier quoted context omitted.

What you can also read on that linked page is that the only thing you cannot do when using the Timescale license is basically pull an AWS move and sell TimescaleDB as a service. So when you say "closed source" and "proprietary" that's just really not a good description of TImescaleDB imo. (on the other hand you can grab the Apache version and sell it as a DBaaS etc)

>>"closed source" and "proprietary" that's just really not a good description of TimescaleDB I suppose we can agree to disagree on this. Perhaps "Open Core, Source Available" is a term you can agree to? I think my original comment was clear that part of Timescale is Open Source, or in other words Open Core. >> the only thing you cannot do when using the Timescale license is basically pull an AWS move and sell Timesca…

Yeah I suppose that's a valid concern. Even though, you can still choose between major cloud providers inside Timescale Cloud (AWS / GCP currently as I know) so there's that. But it needs to be through Timescale the company (unless you are ok with managing it yourself because in that case you can use the Timescale license and go to any hosting provider). So yeah I agree there's some lock-in but I don't see any other reasonable option for a company to generate revenue without any vendor lock-in

Re: TimescaleDB vs ClickHouse

#72

Post by PeterZaitsev »

eatonphil wrote: post #34
PeterZaitsev wrote: post #9

Wait was not TimescaleDB completely leave Clickhouse in the dust both in terms of query performance and compression ? https://blog.timescale.com/blog/what-is-clickhouse-how-does-... I think this series of posts confirms the first law of Benchmarketing - for any system one can come up with "unbiased" benchmark which confirms its superiority

Calling this "benchmarketing" sounds like you're saying the entire thing is disreputable which doesn't seem right. This blog post didn't remotely come off as shilling to me. The author does not (seem to) work for either company. They gave it a shot and shared a result. Whether or not it's a good benchmark or representative for your (anyone's) use case is debatable.

I was rather referring to original TimescaleDB article which claims what unlike some others these are real benchmarks, and I encourage all benchmark (including ours at Percona) to be taken with a pound of salt because they tend to have implicit, if not intentional biases and have rather real applicability to real world.

Re: TimescaleDB vs ClickHouse

#73

Post by eatonphil »

PeterZaitsev wrote: post #72
eatonphil wrote: post #34

Earlier quoted context omitted.

Calling this "benchmarketing" sounds like you're saying the entire thing is disreputable which doesn't seem right. This blog post didn't remotely come off as shilling to me. The author does not (seem to) work for either company. They gave it a shot and shared a result. Whether or not it's a good benchmark or representative for your (anyone's) use case is debatable.

I was rather referring to original TimescaleDB article which claims what unlike some others these are real benchmarks, and I encourage all benchmark (including ours at Percona) to be taken with a pound of salt because they tend to have implicit, if not intentional biases and have rather real applicability to real world.

Makes sense, thanks for clarifying!

Re: TimescaleDB vs ClickHouse

#75

Post by sin7 »

jasfi wrote: post #59
sin7 wrote: post #28

Earlier quoted context omitted.

The answer is yes. I used ClickHouse to calculate and forecast sales of products at a dozen or so stores. The compression was huge because it's essentially the same data every day except for changes to the inventory. At the time I checked vanilla PostgreSQL, TimeScaleDB and ClickHouse. It wasn't even close when it came to storage or performance. ClickHouse allowed me to work off of an old workstation where I installe…

What was your opinion of Postgres vs the others?

PostgreSQL is not in the game. Completely different purposes. PostgreSQL is great for what it's meant to do. Analytics is not it. Reads are too slow.

Re: TimescaleDB vs ClickHouse

#76

Post by akulkarni »

PeterZaitsev wrote: post #25
akulkarni wrote: post #18

(Timescale co-founder) I'll answer this here with a similar response that I gave Pradeep (the author) via Twitter. I think ClickHouse is a great technology. It totally beats TimescaleDB for OLAP queries. I'll be the first to admit that. What our (100+ hour, 3 month analysis) benchmark showed is that for _time-series workloads_, TimescaleDB fared better. [0] Pradeep's analysis - while earnest - is essentially comparin…

I think TimescaleDB is amazing piece of technology but I think you're making arguments much broader than they can be made based on the facts. The results which TimescaleDB showed to me seems to show what it is better than ClickHouse in TSBS benchmark (or particular configuration) not for Time Series workloads in general. In my experience "Time Series" workloads can be defined very broadly (by casual user) and queryin…

If you would like to discuss facts: We have witnessed 100,000s+ of different time-series workloads over the past 4.5 years, and the patterns they share may surprise you. There is much more similarity than you may think - similarities that have been captured in the TSBS (and described by other TimescaleDB users in this discussion thread).

So while we can debate on an academic level what a "time-series" workload is, if we were to look at the facts we will find that the answer is far more specified that you may think.

Also, Peter, I wonder if you should be more forthcoming with your ClickHouse affiliation.

Everyone reading this thread is aware of my bias because I clearly state my TimescaleDB affiliation. But I didn't realize until very recently (when someone pointed this out to me) that you are affiliated with ClickHouse - eg perhaps as an investor or even founder in Altinity?

It is best practice on Hacker News to be forthcoming with affiliations so that readers can make their own decisions on how to correct for any natural biases made by commenters.

Post reply on HN