2.6.0 (2022-02-16)
This release is a medium priority for upgrade. We recommend that you upgrade at the next available opportunity.
This release adds major new features since the 2.5.2 release, including:
- Continuous aggregates with compression
- time_bucket_ng support for N months and timezones on continuous aggregates
- You can read more about this release on our blog post. This release also contains bug fixes since the 2.5.0 release.
The experimental features in the 2.6 release are:
- The time_bucket_ng function, a newer version of time_bucket. This function supports years, months, days, hours, minutes, seconds, and timezones.
- time_bucket_ng support for N months and Timezones on continuous aggregates.
- APIs for chunk manipulation across data nodes in a distributed hypertable setup. This includes the ability to add a data node and move chunks to the new data node for cluster rebalancing.
Features
- #3768 Allow ALTER TABLE ADD COLUMN with DEFAULT on compressed hypertable
- #3769 Allow ALTER TABLE DROP COLUMN on compressed hypertable
- #3873 Enable compression on continuous aggregates
- #3943 Optimize first/last
- #3945 Add support for ALTER SCHEMA on multi-node
- #3949 Add support for DROP SCHEMA on multi-node
- #3977 Timezones support in CAGGs
Bugfixes
- #3808 Properly handle max_retries option
- #3863 Fix remote transaction heal logic
- #3869 Fix ALTER SET/DROP NULL contstraint on distributed hypertable
- #3944 Fix segfault in add_compression_policy
- #3961 Fix crash in EXPLAIN VERBOSE on distributed hypertable
- #4015 Eliminate float rounding instabilities in interpolate
- #4019 Update ts_extension_oid in transitioning state
- #4073 Fix buffer overflow in partition scheme
Improvements
Query planning performance is improved for hypertables with a large number of chunks.
Thanks
- @fvannee for reporting a first/last memory leak
- @mmouterde for reporting an issue with floats and interpolate