TimescaleDB extension version 2.14.2 is now available for Aiven for PostgreSQL®. It introduces new features, performance improvements, and bug fixes on top of release 2.13.1. Upgrade to 2.14.2 at your earliest convenience to make sure you use the most robust and secure version available.
Refer to the TimescaleDB release notes for 2.14.0, 2.14.1, and 2.14.2 to check all the changes introduced in these releases, including deprecation announcements and operational instructions.
Key new features
- Ability to change compression settings on existing compressed hypertables at any time: New compression settings take effect on any new chunks that are compressed after the change.
- Reduced locking requirements during chunk recompression
- Limiting tuple decompression during DML operations to avoid decompressing a lot of tuples and causing storage issues (100k limit, configurable)
- Helper functions for determining compression settings
- Plan-time chunk exclusion for real-time Continuous Aggregate by constify the cagg_watermark function call
More new features
- Add views for per chunk compression settings #6630
- Add plan-time chunk exclusion for real-time CAggs #6325
- Remove support for creating Continuous Aggregates with old format #6360
- Add functions for determining compression defaults #6386
- Remove multinode public API #6410
- Allow SQLValueFunction pushdown into compressed scan #6440
- Support approximate hypertable size #6463
- Make compression settings per chunk #6513
- Remove reindex_relation from recompression #6529
- Fix if_not_exists behavior for CAgg policy with NULL offsets #6531
- Remove restrictions for changing compression settings #6545
- Limit tuple decompression during DML operations #6566
- Change compress_chunk and decompress_chunk to idempotent version by default #6579
- Add LWLock for OSM usage in loader #6608
- Deprecate recompress_chunk #6609
- Add optional recompress argument to compress_chunk #6609
Bug fixes
- Fix segfault in cagg_validate_query #6655
- Fix refresh on empty CAgg with variable bucket #6660
- Don't try to compress osm chunks #6670
- Fix extension update of compressed hypertables with dropped columns #6636
- Reset sequence numbers on non-rollup compression #6637
- Disable default indexscan for compression #6639
- Fix DecompressChunk path generation with per chunk settings #6651
- Inefficient join plans on compressed hypertables #6541
- Enable now() plantime constification with BETWEEN #6491
- Fix create_hypertable referenced by fk succeeds #6494
- Suboptimal query plans when using time_bucket with query parameters #6498
- time_bucket_gapfill with timezones doesn't handle daylight savings #6507
- Make extension state available through function #6509
- Log extension state changes #6512
- Disallow triggers on CAggs #6522
- Reduce locking level on compressed chunk index during segmentwise recompression #6523
- Fix if_not_exists behavior for CAgg policy with NULL offsets #6531
- Fix pathtarget adjustment for MergeAppend paths in aggregation pushdown code #6571
- Fix compressed chunk not found during upserts #6575
- Fix recompression policy ignoring partially compressed chunks #6592
- Ensure qsort comparison function is transitive #6610
