Re:How Time Series Databases Work, and Where They Don’t
by ignoramous on Monday October 18, 2021 @05:28AM
(#28903668)
How does timescale (a single-purpose database) hold up against single-store (a multi-purpose database)? Of course, timescale is cheaper, but other than that, have you folks compared / contrast against single-store as a TSDB?
Re:How Time Series Databases Work, and Where They Don’t
by akulkarni on Monday October 18, 2021 @01:30PM
(#28908109)
TimescaleDB performs quite well. One of our unique insights is that it is quite possible to build a best-in-class time-series database on top of Postgres (although it’s not easy ;-)
Here is one benchmark: https://blog.timescale.com/blog/timescaledb-vs-influxdb-for-...
There are some challenges with building on Postgres - but what we’ve been able to do is build innovative capabilities that overcome these challenges (Eg columnar compression in a row-oriented store, multi-node scale out).
We also have some exciting things that we are announcing this week. Stay tuned :-)
PS - Where did you find that PDF? Thought we took it down (it was hard to keep it up to date :-) )
Re:How Time Series Databases Work, and Where They Don’t
by ignoramous on Tuesday October 19, 2021 @04:08AM
(#28915905)
Thanks.
Re: paper: I stumbled upon it when going through other timescaledb threads on news.yc, specifically here, https://news.ycombinator.com/item?id=13943939 (5 yrs ago)
Thanks for the mention, and I completely agree :-)
Personally, there is a lot in this article that is misguided.
For example, it essentially defines "time-series database" as "metric store." As TimescaleDB users know, TimescaleDB handles a lot more than just metrics. In fact, we handle any of the data types that Postgres can handle, which I suspect is more than what Honeycomb's custom store supports.
This is a broad generalization. Some time-series databases are better at high cardinality than others. Also, what is "high-cardinality" - 100K? 1M? 10M? (We in fact are designed for _higher cardinalities_ than most other time-series databases [0]) We just launched tracing and metrics support in the same backend - in Promscale, built on TimescaleDB [1]I do commend the folks at Honeycomb for having a good product loved by some of my colleagues (at other companies). I also commend them for attempting to write an article aimed to educate. But I wish they had done more research - because without it, this article (IMO) ends up confusing more than educating.
For anyone curious on our definition of "time-series data" and "time-series databases": https://blog.timescale.com/blog/what-the-heck-is-time-series...
[0] https://blog.timescale.com/blog/what-is-high-cardinality-how...
[1] https://blog.timescale.com/blog/what-are-traces-and-how-sql-...