TimescaleDB extension version 2.15.2 is now available for Aiven for PostgreSQL®. It introduces new features, performance improvements, and bug fixes on top of release 2.14.2. Upgrade to 2.15.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.15.2 to check all the changes introduced in this release, including deprecation announcements and operational instructions.
Key new features
- Continuous Aggregate now supports time_bucket with origin and/or offset.
- For hypertable compression:
- Recommend optimized defaults for segment by and order by when configuring compression through analysis of table configuration and statistics.
- Add planner support to check more kinds of WHERE conditions before decompression.
This reduces the number of rows that have to be decompressed. - You can now use minmax sparse indexes when you compress columns with btree indexes.
- Vectorize filters in the WHERE clause that contain text equality operators and LIKE expressions.
More new features
- #6382 Support for time_bucket with origin and offset in CAggs
- #6696 Improve the defaults for compression segment_by and order_by
- #6705 Add sparse minmax indexes for compressed columns that have uncompressed btree indexes
- #6754 Allow DROP CONSTRAINT on compressed hypertables
- #6767 Add metadata table _timestaledb_internal.bgw_job_stat_history for tracking job execution history
- #6798 Prevent the usage of the deprecated time_bucket_ng in the CAgg definition
- #6810 Add telemetry for access methods
- #6811 Remove the no longer relevant timescaledb.allow_install_without_preload GUC
- #6837 Add migration path for CAggs using time_bucket_ng
- #6865 Update the watermark when truncating a CAgg
Deprecation announcements
- You can no longer create continuous aggregates using time_bucket_ng. This feature will be completely removed in the next release. The best practice is to migrate your current continuous aggregates to the new form.
- This is the last release supporting PostgreSQL 13.
Bug fixes
- #6975 Fix sort pushdown for partially compressed chunks.
- #6976 Fix removal of metadata function and update script.
- #6978 Fix segfault in compress_chunk with a primary space partition.
- #6993 Disallow hash partitioning on primary column.
- #6617 Fix error in show_chunks
- #6621 Remove metadata when dropping chunks
- #6677 Fix snapshot usage in CAgg invalidation scanner
- #6698 Define meaning of 0 retries for jobs as no retries
- #6717 Fix handling of compressed tables with primary or unique index in COPY path
- #6726 Fix constify cagg_watermark using window function when querying a CAgg
- #6729 Fix NULL start value handling in CAgg refresh
- #6732 Fix CAgg migration with custom timezone / date format settings
- #6752 Remove custom autovacuum setting from compressed chunks
- #6770 Fix plantime chunk exclusion for OSM chunk
- #6789 Fix deletes with subqueries and compression
- #6796 Fix a crash involving a view on a hypertable
- #6797 Fix foreign key constraint handling on compressed hypertables
- #6816 Fix handling of chunks with no constraints
- #6820 Fix a crash when the ts_hypertable_insert_blocker was called directly
- #6849 Use non-orderby compressed metadata in compressed DML
- #6867 Clean up compression settings when deleting compressed CAgg
- #6869 Fix compressed DML with constraints of form value OP column
- #6870 Fix bool expression pushdown for queries on compressed chunks
