TimescaleDB extension 2.13.0 for Aiven for PostgreSQL^® released

TimescaleDB extension version 2.13.0 is now available for Aiven for PostgreSQL®. It introduces new features and bug fixes on top of release 2.12.2.

Key new features

• Full PostgreSQL 16 support for all existing features
• Vectorized aggregation execution for sum()
• Track chunk creation time used in retention / compression policies

More new features

• Add chunk-wise sorted paths for compressed chunks
• Simplify hypertable DDL API
• Reduce WAL activity by freezing compressed tuples immediately
• Add metadata for chunk creation time
• Make Continuous Aggregates materialized only (non-realtime) by default
• Change show_chunks/drop_chunks using chunk creation time
• Show batches / tuples decompressed during DML operations in EXPLAIN output
• Keep track of catalog version
• Use creation time in retention/compression policy
• Add SQL function cagg_validate_query

Bug fixes

• Add GUC for setting background worker log level
• Allow enabling compression on hypertable with unique expression index
• Check if worker registration succeeded
• Fix exception detail passing in compression_policy_execute
• Fix missing bms_del_member result assignment
• Fix negative bitmapset member not allowed in compression
• Potential data loss when compressing a table with a partial index that matches compression order
• Add support for startup chunk exclusion with aggs
• Repair relacl on upgrade
• Fix segfault when creating a cagg using a NULL width in time bucket function
• Make timescaledb_functions.makeaclitem strict
• Fix typmod and collation for segmentby columns
• Fix tablespace with constraints
• Enable segmentwise recompression in compression policy