Log Message:
postgresql-timescaledb: updated to 2.14.0

2.14.0

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

In addition, it includes these noteworthy 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, leading to faster queries using real-time \ 
continuous aggregates
For this release only, you will need to restart the database before running \ 
ALTER EXTENSION

Multi-node support removal announcement
Following the deprecation announcement for Multi-node in TimescaleDB 2.13,
Multi-node is no longer supported starting with TimescaleDB 2.14.

TimescaleDB 2.13 is the last version that includes multi-node support. Learn \ 
more about it here.

If you want to migrate from multi-node TimescaleDB to single-node TimescaleDB, \ 
read the
migration documentation.

Deprecation notice: recompress_chunk procedure
TimescaleDB 2.14 is the last version that will include the recompress_chunk \ 
procedure. Its
functionality will be replaced by the compress_chunk function, which, starting \ 
on TimescaleDB 2.14,
works on both uncompressed and partially compressed chunks.
The compress_chunk function should be used going forward to fully compress all \ 
types of chunks or even recompress
old fully compressed chunks using new compression settings (through the newly \ 
introduced recompress optional parameter).

Features

* Add plan-time chunk exclusion for real-time CAggs
* Remove support for creating Continuous Aggregates with old format
* Add functions for determining compression defaults
* Remove multinode public API
* Allow SQLValueFunction pushdown into compressed scan
* Support approximate hypertable size
* Make compression settings per chunk
* Remove reindex_relation from recompression
* Fix if_not_exists behavior for CAgg policy with NULL offsets
* Remove restrictions for changing compression settings
* Limit tuple decompression during DML operations
* Change compress_chunk and decompress_chunk to idempotent version by default
* Add LWLock for OSM usage in loader
* Deprecate recompress_chunk
* Add optional recompress argument to compress_chunk

Bugfixes

* Inefficient join plans on compressed hypertables.
* Enable now() plantime constification with BETWEEN
* Fix create_hypertable referenced by fk succeeds
* Suboptimal query plans when using time_bucket with query parameters
* time_bucket_gapfill with timezones doesn't handle daylight savings
* Make extension state available through function
* Log extension state changes
* Disallow triggers on CAggs
* Reduce locking level on compressed chunk index during segmentwise recompression
* Fix if_not_exists behavior for CAgg policy with NULL offsets
* Fix pathtarget adjustment for MergeAppend paths in aggregation pushdown code
* Fix compressed chunk not found during upserts
* Fix recompression policy ignoring partially compressed chunks
* Ensure qsort comparison function is transitive