Company
Date Published
Author
JF Joly
Word count
621
Language
English
Hacker News points
None

Summary

TimescaleDB 2.8 is now available on Timescale Cloud and for download, featuring new features such as improved time_bucket hyperfunction capabilities including support for bucketing by month, year, and time zone, enabling easier time-based queries and reporting. The database also includes a one-step policy management feature for continuous aggregates, allowing users to add, remove, or modify multiple policies in a single command. Additionally, performance improvements have been made for distributed hypertables using the COPY protocol for high data volume queries, and hypertables now support ON CONFLICT ON CONSTRAINT UPSERT statements, enhancing compatibility with certain middlewares. The upgrade is automatic for Timescale Cloud users, while self-hosting users can follow the upgrade instructions in the documentation.