Timescaledb: 2.18.1 Release

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

Features

• https://github.com/timescale/timescaledb/pull/7656 Remove limitation of compression policy for continuous aggregates

Bugfixes

• https://github.com/timescale/timescaledb/pull/7600 Fix lock order when dropping index
• https://github.com/timescale/timescaledb/pull/7637 Allow EXPLAIN in read-only mode
• https://github.com/timescale/timescaledb/pull/7645 Fix DELETE on compressed chunk with non-btree operators
• https://github.com/timescale/timescaledb/pull/7649 Allow non-btree operator pushdown in UPDATE/DELETE queries on compressed chunks
• https://github.com/timescale/timescaledb/pull/7653 Push down orderby scankeys to Hypercore TAM
• https://github.com/timescale/timescaledb/pull/7665 Block merging of frozen chunks
• https://github.com/timescale/timescaledb/pull/7673 Don't abort additional INSERTs when hitting first conflict

GUCs

• enable_hypercore_scankey_pushdown: Push down qualifiers as scankeys when using Hypercore TAM introduced with https://github.com/timescale/timescaledb/pull/7653

Thanks

• @bjornuppeke for reporting a problem with INSERT INTO ... ON CONFLICT DO NOTHING on compressed chunks
• @ikalafat for reporting a problem with EXPLAIN in read-only mode
• Timescale community members Jacob and pantonis for reporting issues with slow queries.