Company
Date Published
Author
Ryan Booz
Word count
4086
Language
English
Hacker News points
146

Summary

TimescaleDB 2.7 introduces dramatic performance improvements in continuous aggregates, up to 44,000x faster than previous versions, as well as significant storage savings of 60% on average. The new version allows for more flexibility and easier management of materialized views, enabling users to use standard PostgreSQL aggregate functions with `FILTER`, `DISTINCT`, and other SQL features. Additionally, the performance improvements are accompanied by a reduction in storage requirements, making it an attractive solution for time-series data analysis. With these enhancements, TimescaleDB 2.7 is poised to become a leading relational database for time-series and analytics workloads.