Timescaledb Versions Save

This release contains bug fixes since the 2.14.1 release. We recommend that you upgrade at the next available opportunity.

Bugfixes

• #6655 Fix segfault in cagg_validate_query
• #6660 Fix refresh on empty CAgg with variable bucket
• #6670 Don't try to compress osm chunks

Thanks

• @kav23alex for reporting a segfault in cagg_validate_query

This release contains bug fixes since the 2.14.0 release. We recommend that you upgrade at the next available opportunity.

Features

• #6630 Add views for per chunk compression settings

Bugfixes

• #6636 Fixes extension update of compressed hypertables with dropped columns
• #6637 Reset sequence numbers on non-rollup compression
• #6639 Disable default indexscan for compression
• #6651 Fix DecompressChunk path generation with per chunk settings

Thanks

• @anajavi for reporting an issue with extension update of compressed hypertables

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 constifying 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

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

Bugfixes

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

Thanks

• @coney21 and @GStechschulte for reporting the problem with inefficient join plans on compressed hypertables.
• @HollowMan6 for reporting triggers not working on materialized views of CAggs
• @jbx1 for reporting suboptimal query plans when using time_bucket with query parameters
• @JerkoNikolic for reporting the issue with gapfill and DST
• @pdipesh02 for working on removing the old Continuous Aggregate format
• @raymalt and @martinhale for reporting very slow query plans on realtime CAggs queries

This release contains bug fixes since the 2.13.0 release. We recommend that you upgrade at the next available opportunity.

Bugfixes

• #6365 Use numrows_pre_compression in approximate row count
• #6377 Use processed group clauses in PG16
• #6384 Change bgw_log_level to use PGC_SUSET
• #6393 Disable vectorized sum for expressions.
• #6405 Read CAgg watermark from materialized data
• #6408 Fix groupby pathkeys for gapfill in PG16
• #6428 Fix index matching during DML decompression
• #6439 Fix compressed chunk permission handling on PG16
• #6443 Fix lost concurrent CAgg updates
• #6454 Fix unique expression indexes on compressed chunks
• #6465 Fix use of freed path in decompression sort logic

Thanks

• @MA-MacDonald for reporting an issue with gapfill in PG16
• @aarondglover for reporting an issue with unique expression indexes on compressed chunks
• @adriangb for reporting an issue with security barrier views on pg16

This release contains performance improvements, an improved hypertable DDL API and bug fixes since the 2.12.2 release. We recommend that you upgrade at the next available opportunity.

In addition, it includes these noteworthy features:

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

Deprecation notice: Multi-node support TimescaleDB 2.13 is the last version that will include multi-node support. Multi-node support in 2.13 is available for PostgreSQL 13, 14 and 15. Learn more about it here.

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

PostgreSQL 13 deprecation announcement We will continue supporting PostgreSQL 13 until April 2024. Sooner to that time, we will announce the specific version of TimescaleDB in which PostgreSQL 13 support will not be included going forward.

Starting from TimescaleDB 2.13.0

• No Amazon Machine Images (AMI) are published. If you previously used AMI, please use another installation method
• Continuous Aggregates are materialized only (non-realtime) by default

Features

• #5575 Add chunk-wise sorted paths for compressed chunks
• #5761 Simplify hypertable DDL API
• #5890 Reduce WAL activity by freezing compressed tuples immediately
• #6050 Vectorized aggregation execution for sum()
• #6062 Add metadata for chunk creation time
• #6077 Make Continous Aggregates materialized only (non-realtime) by default
• #6177 Change show_chunks/drop_chunks using chunk creation time
• #6178 Show batches/tuples decompressed during DML operations in EXPLAIN output
• #6185 Keep track of catalog version
• #6227 Use creation time in retention/compression policy
• #6307 Add SQL function cagg_validate_query

Bugfixes

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

Thanks

• @fetchezar for reporting an issue with compression policy error messages
• @jflambert for reporting the background worker log level issue
• @torazem for reporting an issue with compression and large oids
• @fetchezar for reporting an issue in the compression policy
• @lyp-bobi for reporting an issue with tablespace with constraints
• @pdipesh02 for contributing to the implementation of the metadata for chunk creation time, the generalized hypertable API, and show_chunks/drop_chunks using chunk creation time
• @lkshminarayanan for all his work on PG16 support

This release contains bug fixes since the 2.12.1 release. We recommend that you upgrade at the next available opportunity.

Bugfixes

• #6155 Align gapfill bucket generation with time_bucket
• #6181 Ensure fixed_schedule field is populated
• #6210 Fix EXPLAIN ANALYZE for compressed DML

This release contains bug fixes since the 2.12.0 release. We recommend that you upgrade at the next available opportunity.

Bugfixes

• #6113 Fix planner distributed table count
• #6117 Avoid decompressing batches using an empty slot
• #6123 Fix concurrency errors in OSM API
• #6142 do not throw an error when deprecation GUC cannot be read

Thanks

• @symbx for reporting a crash when selecting from empty hypertables

This release contains performance improvements for compressed hypertables and continuous aggregates and bug fixes since the 2.11.2 release. We recommend that you upgrade at the next available opportunity.

This release moves all internal functions from the _timescaleb_internal schema into the _timescaledb_functions schema. This separates code from internal data objects and improves security by allowing more restrictive permissions for the code schema. If you are calling any of those internal functions you should adjust your code as soon as possible. This version also includes a compatibility layer that allows calling them in the old location but that layer will be removed in 2.14.0.

PostgreSQL 12 support removal announcement Following the deprecation announcement for PostgreSQL 12 in TimescaleDB 2.10, PostgreSQL 12 is not supported starting with TimescaleDB 2.12. Currently supported PostgreSQL major versions are 13, 14 and 15. PostgreSQL 16 support will be added with a following TimescaleDB release.

Features

• https://github.com/timescale/timescaledb/pull/5137 Insert into index during chunk compression
• https://github.com/timescale/timescaledb/pull/5150 MERGE support on hypertables
• https://github.com/timescale/timescaledb/pull/5515 Make hypertables support replica identity
• https://github.com/timescale/timescaledb/pull/5586 Index scan support during UPDATE/DELETE on compressed hypertables
• https://github.com/timescale/timescaledb/pull/5596 Support for partial aggregations at chunk level
• https://github.com/timescale/timescaledb/pull/5599 Enable ChunkAppend for partially compressed chunks
• https://github.com/timescale/timescaledb/pull/5655 Improve the number of parallel workers for decompression
• https://github.com/timescale/timescaledb/pull/5758 Enable altering job schedule type through alter_job
• https://github.com/timescale/timescaledb/pull/5805 Make logrepl markers for (partial) decompressions
• https://github.com/timescale/timescaledb/pull/5809 Relax invalidation threshold table-level lock to row-level when refreshing a Continuous Aggregate
• https://github.com/timescale/timescaledb/pull/5839 Support CAgg names in chunk_detailed_size
• https://github.com/timescale/timescaledb/pull/5852 Make set_chunk_time_interval CAggs aware
• https://github.com/timescale/timescaledb/pull/5868 Allow ALTER TABLE ... REPLICA IDENTITY (FULL|INDEX) on materialized hypertables (continuous aggregates)
• https://github.com/timescale/timescaledb/pull/5875 Add job exit status and runtime to log
• https://github.com/timescale/timescaledb/pull/5909 CREATE INDEX ONLY ON hypertable creates index on chunks

Bugfixes

• https://github.com/timescale/timescaledb/pull/5860 Fix interval calculation for hierarchical CAggs
• https://github.com/timescale/timescaledb/pull/5894 Check unique indexes when enabling compression
• https://github.com/timescale/timescaledb/pull/5951 _timescaledb_internal.create_compressed_chunk doesn't account for existing uncompressed rows
• https://github.com/timescale/timescaledb/pull/5988 Move functions to _timescaledb_functions schema
• https://github.com/timescale/timescaledb/pull/5788 Chunk_create must add an existing table or fail
• https://github.com/timescale/timescaledb/pull/5872 Fix duplicates on partially compressed chunk reads
• https://github.com/timescale/timescaledb/pull/5918 Fix crash in COPY from program returning error
• https://github.com/timescale/timescaledb/pull/5990 Place data in first/last function in correct mctx
• https://github.com/timescale/timescaledb/pull/5991 Call eq_func correctly in time_bucket_gapfill
• https://github.com/timescale/timescaledb/pull/6015 Correct row count in EXPLAIN ANALYZE INSERT .. ON CONFLICT output
• https://github.com/timescale/timescaledb/pull/6035 Fix server crash on UPDATE of compressed chunk
• https://github.com/timescale/timescaledb/pull/6044 Fix server crash when using duplicate segmentby column
• https://github.com/timescale/timescaledb/pull/6045 Fix segfault in set_integer_now_func
• https://github.com/timescale/timescaledb/pull/6053 Fix approximate_row_count for CAggs
• https://github.com/timescale/timescaledb/pull/6081 Improve compressed DML datatype handling
• https://github.com/timescale/timescaledb/pull/6084 Propagate parameter changes to decompress child nodes
• https://github.com/timescale/timescaledb/pull/6102 Schedule compression policy more often

Thanks

• @ajcanterbury for reporting a problem with lateral joins on compressed chunks
• @alexanderlaw for reporting multiple server crashes
• @lukaskirner for reporting a bug with monthly continuous aggregates
• @mrksngl for reporting a bug with unusual user names
• @willsbit for reporting a crash in time_bucket_gapfill

This release contains bug fixes since the 2.11.1 release. We recommend that you upgrade at the next available opportunity.

Features

• #5923 Feature flags for TimescaleDB features

Bugfixes

• #5680 Fix DISTINCT query with JOIN on multiple segmentby columns
• #5774 Fixed two bugs in decompression sorted merge code
• #5786 Ensure pg_config --cppflags are passed
• #5906 Fix quoting owners in sql scripts.
• #5912 Fix crash in 1-step integer policy creation

Thanks

• @mrksngl for submitting a PR to fix extension upgrade scripts
• @ericdevries for reporting an issue with DISTINCT queries using segmentby columns of compressed hypertable

This release contains bug fixes since the 2.11.0 release. We recommend that you upgrade at the next available opportunity.

Features

• #5679 Update the loader to add support for the OSM extension (used for data tiering on Timescale)

Bugfixes

• #5705 Scheduler accidentally getting killed when calling delete_job
• #5742 Fix Result node handling with ConstraintAwareAppend on compressed chunks
• #5750 Ensure tlist is present in decompress chunk plan
• #5754 Fixed handling of NULL values in bookend_sfunc
• #5798 Fixed batch look ahead in compressed sorted merge
• #5804 Mark cagg_watermark function as PARALLEL RESTRICTED
• #5807 Copy job config JSONB structure into current MemoryContext
• #5824 Improve continuous aggregate query chunk exclusion

Thanks

• @JamieD9 for reporting an issue with a wrong result ordering
• @xvaara for reporting an issue with Result node handling in ConstraintAwareAppend