Company
Date Published
Author
Team Timescale
Word count
1010
Language
English
Hacker News points
None

Summary

TimescaleDB 1.6 has been released, bringing significant updates to continuous aggregates and other enhancements. Continuous aggregates allow users to speed up queries that aggregate over time, particularly useful for real-time dashboards and IoT sensor data. The new release introduces the ability to use a data retention policy with continuous aggregates, enabling users to save resources and storage space while maintaining continuous aggregates. This feature allows users to control the amount of data stored and remove underlying data once it has served its purpose, saving on storage costs. Additionally, the release includes an option to turn off data invalidation, which can improve performance and reduce resource consumption. Users can also use native compression to save on storage costs if they need to retain all their old data. The new update aims to provide more efficient storage strategies around downsampling and faster build and refresh times, making it easier for users to manage large datasets.