Company
Date Published
Author
Nuno Santos
Word count
2957
Language
English
Hacker News points
None

Summary

TimescaleDB 2.6 has been released with new features highly requested by the community, including compression for continuous aggregates and support for timezones in continuous aggregates. Compression allows users to save disk space by compressing data stored in a specific hypertable that is older than a certain period of time. The feature uses best-in-class compression algorithms along with a novel hybrid row/columnar storage design. Additionally, the new release includes an experimental feature called `time_bucket_ng`, which expands on the capabilities of the existing `time_bucket` hyperfunction by including features such as monthly buckets and timezones. This allows users to create continuous aggregates that can be used for downsampling and long-term analytics, while also reducing storage costs. The release is available now for Timescale Cloud and self-managed TimescaleDB instances.