News for hackers. Stuff that matters.

A comment on Why Not to Build a Time-Series Database. Parent comment

Re:Why Not to Build a Time-Series Database by car10s on Wednesday November 07, 2018 @10:36PM (#18404170)
Vertica has this functionality and it has been there for years. Fully functional database and you can do time series joins, gap filling with linear interpolation or constant. You can define the intervals at what you want the data points. And you can scale from a few gigs to petabytes of data. https://www.vertica.com/docs/9.1.x/HTML/index.htm#Authoring/...
[ Parent | on HN ]
Re:Why Not to Build a Time-Series Database by ghc on Wednesday November 07, 2018 @11:06PM (#18404260)
I agree! Vertica's temporal capabilities are marvelous and the engineers who worked on the planner optimizations for the time extensions are brilliant.

There are of course trade-offs to the approach Vertica takes -- look at StreamBase for a very different take on the problem, another Stonebraker project.

Any of course historians represent yet another take, optimized for point-in time queries that are native and don't need the processing extensions Vertica uses.

[ Parent | on HN ]