Company
Date Published
Author
Sven Klemm
Word count
3269
Language
English
Hacker News points
None

Summary

Real-time aggregates are a new feature in TimescaleDB that allows for fast and accurate queries over high-volume time-series data. They build on continuous aggregates, which can improve query performance and optimize storage, but also introduce some latency. Real-time aggregation addresses this limitation by combining pre-computed aggregates with raw data from the underlying hypertable, providing up-to-date results while still enjoying the speedups of pre-computing a large portion of the result. This feature is particularly useful for use cases such as devops monitoring, real-time analytics, and IoT, where fast queries over high-volume workloads and accurate, real-time results really matter.