TimescaleDB Files

This release contains performance improvements and bug fixes since the 2.22.0 release. We recommend that you upgrade at the next available opportunity.

This release blocks the ability to leverage concurrent refresh policies in hierarchical continous aggregates, as potential deadlocks can occur. If you have concurrent refresh policies in hierarchical continous aggregates, please disable the jobs, as following:

SELECT alter_job("<job_id_of_concurrent_policy>", scheduled => false);

Bugfixes * #7766 Load OSM extension in retention background worker to drop tiered chunks * #8550 Error in gapfill with expressions over aggregates and groupby columns and out-of-order columns * #8593 Error on change of invalidation method for continuous aggregate * #8599 Fix attnum mismatch bug in chunk constraint checks * #8607 Fix interrupted continous aggregate refresh materialization phase leaving behind pending materialization ranges * #8638 ALTER TABLE RESET for orderby settings * #8644 Fix migration script for sparse index configuration * #8657 Fix CREATE TABLE WITH when using UUIDv7 partitioning * #8659 Don't propagate ALTER TABLE commands to foreign data wrapper chunks * #8693 Compressed index not chosen for varchar typed segmentby columns * #8707 Block concurrent refresh policies for hierarchical continous aggregate due to potential deadlocks

Thanks * @MKrkkl for reporting a bug in Gapfill queries with expressions over aggregates and groupby columns * @brandonpurcell-dev for creating a test case that showed a bug in CREATE TABLE WITH when using UUIDv7 partitioning * @snyrkill for reporting a bug when interrupting a continous aggregate refresh