2.9.0 (2022-12-15)

This release adds major new features since the 2.8.1 release.
We deem it moderate priority for upgrading.

This release includes these noteworthy features:

• Hierarchical Continuous Aggregates (aka Continuous Aggregate on top of another Continuous Aggregate)
• Improve time_bucket_gapfill function to allow specifying the timezone to bucket
• Introduce fixed schedules for background jobs and the ability to check job errors.
• Use alter_data_node() to change the data node configuration. This function introduces the option to configure the availability of the data node.

This release also includes several bug fixes.

Features

• #4476 Batch rows on access node for distributed COPY
• #4567 Exponentially backoff when out of background workers
• #4650 Show warnings when not following best practices
• #4664 Introduce fixed schedules for background jobs
• #4668 Hierarchical Continuous Aggregates
• #4670 Add timezone support to time_bucket_gapfill
• #4678 Add interface for troubleshooting job failures
• #4718 Add ability to merge chunks while compressing
• #4786 Extend the now() optimization to also apply to CURRENT_TIMESTAMP
• #4820 Support parameterized data node scans in joins
• #4830 Add function to change configuration of a data nodes
• #4966 Handle DML activity when datanode is not available
• #4971 Add function to drop stale chunks on a datanode

Bugfixes

• #4663 Don't error when compression metadata is missing
• #4673 Fix now() constification for VIEWs
• #4681 Fix compression_chunk_size primary key
• #4696 Report warning when enabling compression on hypertable
• #4745 Fix FK constraint violation error while insert into hypertable which references partitioned table
• #4756 Improve compression job IO performance
• #4770 Continue compressing other chunks after an error
• #4794 Fix degraded performance seen on timescaledb_internal.hypertable_local_size() function
• #4807 Fix segmentation fault during INSERT into compressed hypertable
• #4822 Fix missing segmentby compression option in CAGGs
• #4823 Fix a crash that could occur when using nested user-defined functions with hypertables
• #4840 Fix performance regressions in the copy code
• #4860 Block multi-statement DDL command in one query
• #4898 Fix cagg migration failure when trying to resume
• #4904 Remove BitmapScan support in DecompressChunk
• #4906 Fix a performance regression in the query planner by speeding up frozen chunk state checks
• #4910 Fix a typo in process_compressed_data_out
• #4918 Cagg migration orphans cagg policy
• #4941 Restrict usage of the old format (pre 2.7) of continuous aggregates in PostgreSQL 15.
• #4955 Fix cagg migration for hypertables using timestamp without timezone
• #4968 Check for interrupts in gapfill main loop
• #4988 Fix cagg migration crash when refreshing the newly created cagg * #5054 Fix segfault after second ANALYZE
• #5086 Reset baserel cache on invalid hypertable cache

Thanks

• @byazici for reporting a problem with segmentby on compressed caggs
• @jflambert for reporting a crash with nested user-defined functions.
• @jvanns for reporting hypertable FK reference to vanilla PostgreSQL partitioned table doesn't seem to work
• @kou for fixing a typo in process_compressed_data_out
• @kyrias for reporting a crash when ANALYZE is executed on extended query protocol mode with extension loaded.
• @tobiasdirksen for requesting Continuous aggregate on top of another continuous aggregate
• @Xima for reporting a bug in Cagg migration
• @xvaara for helping reproduce a bug with bitmap scans in transparent decompression