TimescaleDB extension version 2.21.0 is now available for Aiven for PostgreSQL®. Upgrade to 2.21.0 at your earliest convenience to make sure you use the most robust and secure version available. This release introduces the following:
Features
- #8081 Use JSON error code for job configuration parsing
- #8100 Support splitting compressed chunks
- #8131 Add policy to process hypertable invalidations
- #8141 Add function to process hypertable invalidations
- #8165 Reindex recompressed chunks in compression policy
- #8178 Add columnstore option to
CREATE TABLE WITH
- #8179 Implement direct
DELETE
on non-segmentby columns - #8182 Cache information for repeated upserts into the same compressed chunk
- #8187 Allow concurrent Continuous Aggregate refreshes
- #8191 Add option to not process hypertable invalidations
- #8196 Show deprecation warning for TAM
- #8208 Use
NULL
compression for bool batches with all null values like the other compression algorithms - #8223 Support for attach/detach chunk
- #8265 Set incremental Continuous Aggregate refresh policy on by default
- #8274 Allow creating concurrent continuous aggregate refresh policies
- #8314 Add support for
timescaledb_lake
in loader - #8209 Add experimental support for Direct Compress of
COPY
- #8341 Allow quick migration from hypercore TAM to (columnstore) heap
Bug fixes
- #8153 Restoring a database having
NULL
compressed data - #8164 Check columns when creating new chunk from table
- #8294 The "vectorized predicate called for a null value" error for
WHERE
conditions like x = any(null::int[])
. - #8307 Fix missing catalog entries for bool and null compression in fresh installations
- #8323 Fix DML issue with expression indexes and BHS
GUCs
enable_direct_compress_copy
: Enable experimental support for direct compression during COPY
, default: off
enable_direct_compress_copy_sort_batches
: Enable batch sorting during direct compress COPY
, default: on
enable_direct_compress_copy_client_sorted
: Correct handling of data sorting by the user is required for this option, default: off
Deprecation
See the release notes for all TimescaleDB releases.