How Time Series Databases Work, and Where They Don’t

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?

PS https://www.timescale.com/papers/timescaledb.pdf is 404

[ Parent | on HN ]

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 :-) )

[ Parent | on HN ]

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)

[ Parent | on HN ]