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
- #7656 Remove limitation of compression policy for continuous aggregates
Bugfixes
- #7600 Fix lock order when dropping index
- #7637 Allow EXPLAIN in read-only mode
- #7645 Fix DELETE on compressed chunk with non-btree operators
- #7649 Allow non-btree operator pushdown in UPDATE/DELETE queries on compressed chunks
- #7653 Push down orderby scankeys to Hypercore TAM
- #7665 Block merging of frozen chunks
- #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 #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.