timescale/timescaledb
 Watch   
 Star   
 Fork   
4 days ago
timescaledb

2.32.0 (2026-11-12)

This release includes security fixes, performance improvements, and bug fixes since 2.31.0. As part of our ongoing proactive security reviews, this release includes a larger set of security fixes than usual. We recommend that you upgrade as soon as possible.

Loader Changes For the loader changes take effect a PostgreSQL restart is required.

  • #10966 Check database ownership before stopping or restarting background workers on database commands
  • #10983 Run the background worker scheduler as the database owner instead of as superuser

Features

  • #10864 Improve continuous aggregate refresh performance by updating the watermark once per batch
  • #10878 Enable Adaptive Integer Compression (AIC) by default
  • #10927 Remove user switching when allocating ids from the internal catalog sequences
  • #10953 Allow database owners to start, stop, and restart background workers without superuser
  • #10960 Run the telemetry job as the database owner instead of the role that installed the extension

Bugfixes

  • #10075 Removing the bloom1_contains function and rejecting anonymous record arrays in bloom1_contains_any
  • #10296, #10745 Fix continuous aggregate refresh skipping the last invalidated bucket for variable-sized buckets
  • #10854 Correctly skip rows with conversion errors during COPY FROM ON_ERROR ignore
  • #10855 Enforce REJECT_LIMIT during COPY FROM on PostgreSQL 18 and later
  • #10887 Fix "repalloc called with invalid pointer" when compressing batches of more than 992 rows for certain data patterns
  • #10893 Fix typo in the columnar README example
  • #10902 Fix concurrent UPDATE/DELETE on hypertables silently skipping rows under READ COMMITTED
  • #10919 Check schema CREATE privilege when creating a continuous aggregate
  • #10925 Create chunk constraints without switching to the catalog owner
  • #10961 Fix crash in decompress_chunk when the hypertable is dropped concurrently
  • #10961 Fix null dereference in in-memory recompression when the compression settings are missing
  • #10961 Fix stale chunk and hypertable state in compress_chunk when a concurrent decompress or compression change commits
  • #10962 Reset search_path after every COMMIT in the columnstore policy
  • #10964 Fix crash in cagg_validate_query when called with a SELECT INTO statement
  • #10964 Fix crash in cagg_validate_query when the user lacks SELECT permission on the hypertable
  • #10965 Verify the server certificate on telemetry SSL connections
  • #10967 Fix crash in show_policies when called more than once in the same query
  • #10968 Fix crash in add_policies and alter_policies when a drop_created_before retention policy exists on the hypertable or the continuous aggregate
  • #10970 Fix ORDER BY pushdown for realtime continuous aggregates with an ORDER BY in their definition
  • #10988 Report a missing policy config key as a user error instead of an internal error
  • #10988 Restrict changing the config check function of a job to the job ownerwhat
  • #10989 Match job procedures by OID in DDL hooks
  • #10991 Fix function overload in approximate_row_count
  • #10993 Require ownership of the chunk, not just of the hypertable, to do chunk operations on them

GUCs

  • compression_orderby_default_function: Function to use for calculating default order_by setting for compression. Default: timescaledb.compression_orderby_default_function
  • compression_segmentby_default_function: Function to use for calculating default segment_by setting for compression. Default: timescaledb.compression_segmentby_default_function

Thanks

  • @JoongHyuk-Shin for fixing continuous aggregate refresh skipping the last invalidated bucket for variable-width buckets, 10419
  • @manishnithinreddy for reporting the concurrent UPDATE/DELETE regression and bisecting it to 2.28.1, 10902
  • @martin-omacht for reporting missing and stale buckets in a continuous aggregate with a timezone, #10296
  • @owhiterabbito for reporting the compression error and analyzing the selector buffer size, #10887
  • @pei711 for fixing a typo in the README, #10893
  • @salmanazmat666 for reporting the continuous aggregate refresh skipping the last bucket on a variable-width bucket boundary, #10745
26 days ago
timescaledb

2.31.0 (2026-10-20)

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

Highlighted features in TimescaleDB v2.31.0

  • Improved performance for UPDATE and DELETE queries on the columnstore with vectorized key processing for bulk decompression. The vectorized aggregation makes DML and recompression operations faster through parallelism, when a single-chunk query groups by an expression, resulting in up to 6.5 times faster queries.
  • Preview of the new Adaptive Integer Compressor (AIC), which chooses the best encoding for each block of integer values. This results in the up to 20% improvement in compression ratios for integers, while queries benefiting from faster decompression perform up to two times better. AIC is disabled by default in this release and will be enabled by default in the 2.32.0 release.

Loader changes This release allows controlling extension hook order to improve compatibility with other extensions. To ensure pgaudit hooks work together with timescaledb, pgaudit must come after timescaledb in shared_preload_libraries setting. This loader change, requires a PostgreSQL restart to enable the compatibility, but if you have no need to control the hook order, the previous loader version is enough, and you don't require a service restart.

Backward-Incompatible Changes

  • #10666 Rename timescaledb.enable_columnarscan to timescaledb.debug_enable_columnarscan to make its debugging-only purpose explicit
  • #10772 Make the direct-compress batch sorting GUCs available only in debug builds

Features

  • #9737 Speed up aggregation with time_bucket_gapfill() by performing aggregation per chunk
  • #10412 Exclude chunks at execution time when a hypertable is on the parameterized side of a nested-loop join
  • #10512 Block ALTER and DROP operations on a granular-refresh tracking column
  • #10517 Block granular refresh on a continuous aggregate's materialization hypertable
  • #10546 Add an API to disable granular refresh on a hypertable
  • #10588 Allow changing the granular refresh offsets of a hypertable
  • #10589 Add informational views for granular refresh
  • #10626 Add the experimental Adaptive Integer Compressor (AIC)
  • #10632 Add move_to_columnstore() to compress chunk rows without blocking concurrent DML
  • #10647 Report continuous aggregate refresh statistics
  • #10678 Use vectorized key processing for UPDATE and DELETE
  • #10705 Use vectorized aggregation when a single-chunk query groups by an expression
  • #10724 Use bulk decompression in UPDATE, DELETE, and recompression
  • #10730 Add timescaledb.cagg_refresh_stats_level to control continuous aggregate refresh statistics
  • #10770 Answer eligible LIMIT 1 queries on compressed chunks from batch metadata without decompression
  • #10780 Report materialized and deleted row counts in the continuous aggregate refresh statistics
  • #10781 Flush continuous aggregate tenant tracking only once per refresh call

Bugfixes

  • #10418 Fix a hypertable COPY crash when pgAudit is enabled
  • #10454 Make SkipScan use the correct index column when distinct columns are equivalent
  • #10558 Fix wrong query results for chunk skipping columns at the maximum value of a chunk or after DML on a compressed chunk
  • #10616 Harden the DeferredChunkAppend deparse and parse cycle
  • #10617 Use compressed indexes for joins on segment-by columns with explicit casts, and prevent sort pushdown when the query and compression keys use different operator families
  • #10630 Exclude hash-partitioned chunks at execution time on the parameterized side of a nested loop, while respecting nondeterministic collations
  • #10635 Use the default B-tree operator when evaluating first() and last() aggregates
  • #10639 Report rows moved to the columnstore clearly
  • #10651 Avoid evaluating expressions over GROUP BY columns twice in single-chunk vectorized aggregation
  • #10693 Use the unique index's collation when checking compressed inserts for conflicts
  • #10701 Mark the result of merge_chunks() unordered when merged chunks can contain overlapping batches
  • #10715 Truncate both the rowstore and columnstore parts of a partially compressed chunk
  • #10718 Preserve foreign keys that reference a hypertable during TRUNCATE ... CASCADE, and allow compress_chunk() on referenced hypertables
  • #10749 Fix an infinite refresh loop for continuous aggregates with variable-sized buckets and negative offsets
  • #10747 Propagate changed parameters when rescanning a ColumnarIndexScan
  • #10748 Propagate changed parameters when rescanning a ConstraintAwareAppend
  • #10795 Preserve compression order for rows written before adding an order-by column with a default
  • #10763 Fix a potential ChunkAppend segfault when parameterized clauses are removed from every chunk
  • #10765 Allow negative day offsets for the date variant of time_bucket()
  • #10778 Do not use SkipScan below a subquery with pseudoconstant qualifiers on the subquery result
  • #10791 Fix potential data loss when direct compression automatically selects segment-by columns
  • #10797 Preserve default values when splitting or merging compressed chunks after ADD COLUMN
  • #10806 Do not push parallel-unsafe aggregate expressions below a Gather during chunkwise aggregation
  • #10808 Speed up chunk creation in databases with many constraints
  • #10817 Fix DeferredChunkAppend planning chunk queries with a restricted search_path
  • #10783 Fix missing continuous aggregate invalidation when dropping a chunk by unqualified name
  • #10827 Validate the full 64-bit version of statement-tracking callbacks
  • #10830 Fix split_chunk routing rows to the wrong chunk
  • #10883 Fix bloom filters not being used on compressed chunks after renaming a column
  • #10508 Fix missing CAgg invalidations during MERGE UPDATE/DELETE
  • #10844 Keep owner of user-defined jobs when hypertable owner changes

New Settings

  • timescaledb.cagg_refresh_stats_level: controls continuous aggregate refresh statistics. Valid values are off (the default), summary, and verbose_log.
  • timescaledb.enable_aic_compression: enables the experimental Adaptive Integer Compressor. Off by default.
  • timescaledb.enable_columnarscan_metadata_only: answers eligible LIMIT 1 queries on compressed chunks from batch metadata. On by default.
  • timescaledb.move_to_columnstore_tuple_sort_limit: limits how many tuples move_to_columnstore() sorts at once to bound memory usage. Defaults to 0 for no limit.

Thanks

  • @AdrianAcala for fixing a crash with hypertable COPY when pgAudit is enabled #10418
  • @hyeokhee for reporting an error with parallel chunkwise aggregation and subqueries in aggregates #10804 fixed via #10806
  • @igor2x for reporting a performance regression with joins on segment-by columns with explicit casts #10591 fixed via #10617
  • @salmanazmat666 for reporting a refresh that could not be cancelled and ran out of memory #10746 fixed via #10806
  • @jf0x3f for reporting a security issue when changing hypertable owner fixed via #10844
2026-09-29 21:46:28
timescaledb

2.30.2 (2026-09-29)

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

Bugfixes

  • #10665 Fix crash when merging chunks with different column layouts
  • #10668 Fix DROP SCHEMA CASCADE leaving orphaned compressed chunks
  • #10682 Fix vectorized text comparison ignoring a non-deterministic collation given in the query
  • #10609 Fix race while updating granular refresh setting for hypertable
  • #10613 Rename the granular refresh options to timescaledb.cagg_granular_refresh_*
  • #10636 Free the tenant tracker's shared memory when its hypertable is dropped
  • #10585 Potential crash in CREATE TABLE AS query selecting from a compressed hypertable
2026-09-17 16:39:10
timescaledb

2.30.1 (2026-09-17)

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

Bugfixes

  • #10580 Fix missing conflicts for INSERT ... ON CONFLICT with multiple unique constraints
  • #10583 Fix NULL conflict resolution on single-column bloom filtering
  • #10592 Fix duplicate rows from DeferredChunkAppend when LIMIT is not pushed down
  • #10593 Fix cannot cast type cstring error in DeferredChunkAppend queries

Thanks

  • @davidecentioni for reporting the problem with a LIMIT query on a hypertable returning duplicate rows once the plan goes generic #10584
  • @vincentrolfs for reporting the problem of LIMIT query with enum columns and casting #10590
2026-09-08 18:24:47
timescaledb

2.30.0 (08.09.2026)

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

Highlighted features in TimescaleDB v2.30.0 Blazing fast LIMIT queries with the newly introduced DeferredChunkAppend. This custom node reduces planning significantly by delaying chunk expansion. During planning the hypertable stays unexpanded and only during execution are chunks enumerated on demand. Combined with the optimizations to FIRST and LAST sparse indexes, this addition executes last-point queries far more efficiently and quickly. This changes the scaling of the "What is the last reading from this sensor" query from linear with number of chunks to constant if it can be found in the most recent chunk. The true power of the custom node starts to show with increasing amount of chunks, see more elaborate benchmarks.

Features

Bugfixes

GUCs

  • enable_deferred_chunk_append: Custom scan node for hypertables that iterates chunks at execution instead of expanding every chunk at plan time. Default: true.
  • use_custom_toaster: Use a custom TOAST writer for compressed row inserts. Default: false.

Thanks

2026-08-18 16:11:51
timescaledb

2.29.2 (2026-08-18)

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

Bugfixes

  • #10189 Fix user-defined functions named time_bucket causing SQLSTATE XX000
  • #10363 Fix time_bucket_gapfill() with window aggregates over constants
  • #10416 Repair mismatched dimensional CHECK constraints
  • #10423 Fix compressed SkipScan dropping uncompressed rows when sort keys do not match distinct keys
  • #10430 Do not attach SkipScan to mismatched IndexScan paths under MergeAppend
  • #9921 Fix wrong results for IS NULL predicates with min/max sparse-index pushdown

Thanks

  • @borisborelly for reporting incorrect results with COUNT(DISTINCT) due to SkipScan dropping uncompressed rows.
2026-08-04 16:08:23
timescaledb

2.29.1 (2026-08-04)

This release contains performance improvements and bug fixes since the 2.29.0 release and fixes for security vulnerabilities (#10360, #10379, #10386). You can check the security advisory for more information on the vulnerability and the platforms that are affected. We recommend that you upgrade at the next available opportunity.

Bugfixes

  • #10327 Assertion failure in add_dimension() when the hypertable argument is NULL
  • #10339 Fix crash when deleting from a compressed continuous aggregate source
  • #10340 Validate max_batches in compact_chunk()
  • #10352 Reset inherited column and constraint flags on chunks during attach_chunk()
  • #10360 Fix decompressor crashes with malformed compressed data
  • #10369 Fix typo in error message about MERGE support on compressed hypertables
  • #10379 Read hypertable max time value with an ordered scan
  • #10386 Add missing permission checks to internal chunk functions

Thanks

  • @JoongHyuk-Shin for reporting and fixing NULL handling in add_dimension()
  • @igor2x for reporting a typo in a MERGE support error message
  • @mdisec for reporting issues with compressed data validation during decompression
2026-07-28 19:20:50
timescaledb

2.29.0 (2026-07-28)

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

Release Highlights

  • Chunk exclusion for DML operations drastically improves the performance of UPDATE and DELETE statements on hypertables. By acquiring exclusive locks only on the specific chunks being modified rather than the entire hypertable, this enhancement eliminates massive lock contention and keeps high-concurrency workloads running smoothly without unnecessary slowdowns.
  • Intelligent row-by-row decompression enables the query planner to decompress data row-by-row rather than in large batches when an operation prioritizes a fast initial response (such as queries with LIMIT clauses). This dramatically reduces memory overhead and query latency, ensuring lightning-fast performance when you only need to retrieve a small subset of records from your compressed hypertables.

Important: PostgreSQL 15 Support Removed TimescaleDB 2.29.0 removes support for PostgreSQL 15. This release supports PostgreSQL 16, 17, and 18. If you are still running PostgreSQL 15, upgrade PostgreSQL before upgrading to TimescaleDB 2.29.0.

Backward-Incompatible Changes

  • #10041 Remove support for PostgreSQL 15

Features

  • #9315 Speed up DML operations on hypertables by using the optimized TimescaleDB hypertable expansion code instead of the generic PostgreSQL inheritance hierarchy expansion
  • #9534 Speed up expression evaluation in the columnar pipeline by caching common subexpressions
  • #9684 Add _timescaledb_functions.decompress_batch() SQL function
  • #9732 Speed up some queries with small LIMIT by switching to row-by-row query execution pipeline
  • #9917 Decompress less data in DML on compressed hypertables by accounting for prepared statement parameters
  • #9957 Add compact_chunk() function
  • #10048 Support concurrent refresh policies on hierarchical continuous aggregates
  • #10081 Add samplerate argument to _timescaledb_functions.estimate_uncompressed_size()
  • #10100 Skip classifying compressed relations to speed up planning
  • #10118 Don't track compressed relations as separate chunk
  • #10119 Reduce memory usage of INSERT queries using direct compress and spanning multiple chunks
  • #10163 Add a compaction policy for unordered chunks
  • #10204 Don't create separate hypertable catalog entry for hypertables with compression
  • #10217 Initial placeholder version of granular refresh API
  • #10225 Add config_merge parameter to alter_job() for merging jsonb into the existing job configuration
  • #10226 Add recompress_unordered columnstore policy option
  • #10231 Use regclass for storing relation reference in chunk table
  • #10237 Add helper functions for decoding hypertable status
  • #10240 Add the tsdb.direct_compress storage parameter that allows enabling direct compress for a given hypertable independent of global settings
  • #10266 Add max_batches to compact_chunk()
  • #10299 Add continuous_aggs_tenant_tracking and hypertable_cagg_settings catalogs

Bugfixes

  • #10013 Make ownership error messages on continuous aggregates consistent
  • #10052 Result of MIN / MAX aggregate functions in columnar aggregation pipeline possibly inconsistent with plain PostgreSQL result
  • #10071 Prune the real-time branch of hierarchical continuous aggregates at any nesting depth
  • #10143 Fix division by zero when planning time_bucket with zero width
  • #10199 Fix initial_start handling in build_job_info
  • #10213 Cache sort pathkeys per hypertable
  • #10221 Fix incremental refresh skipping the last bucket
  • #10278 Drop job_errors view in bgw_job_stat_history migration
  • #10280 RETURNING clause returned no rows for INSERT using direct compress
  • #10281 Disable direct compress when the destination table has an exclusion constraint so the constraint is still enforced
  • #10282 Only count directly compressed rows toward the command tag when the INSERT sets it
  • #10286 Propagate VACUUM on a chunk to the compressed relation when running on the chunk directly
  • #10302 Fix useless-join removal and self-join elimination for hypertables
  • #10313 Allow running ALTER EXTENSION timescaledb UPDATE inside a transaction block
  • #10315 Fix overlap detection with running max
  • #10324 Fix stale index entries after rebuild_sparse_index() on compressed chunks

GUCs

  • timescaledb.enable_hypertable_expansion_for_dml: allow using the optimized TimescaleDB hypertable expansion code for UPDATE and DELETE instead of the generic PostgreSQL inheritance hierarchy expansion. On by default.

Thanks

  • @FrancescEthon and @ManuelEthon for reporting an issue with incremental refresh skipping the last bucket
  • @h0rn3t for reporting a problem with VACUUM not propagating to the compressed relation
  • @igor2x for reporting an issue with locking during DML statements on hypertables
  • @MaximeEthon for reporting an issue with prepared statement parameters in DML decompression
  • @proddata for reporting a problem when upgrading from 2.15.3 to 2.28.2
  • @tureba for reporting and fixing stale sparse-index entries after rebuild
  • @viniciusrsouza for reporting an issue with hierarchical continuous aggregates
2026-07-16 20:23:23
timescaledb

2.28.3 (2026-07-16)

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

Bugfixes

  • #10082 Wrong result when evaluating a function returning NULL in the columnar query execution pipeline
  • #10178 Fix incorrect usage of sort transformation for sort key expressions with negative constants
  • #10179 Allow enabling and disabling triggers on hypertables with columnstore enabled
  • #10182 Fix columnstore sort pushdown to check for different query sort key collation
  • #10209 Fix potentially wrong results for stddev(float4) and stddev(float8) when used with avg() in the columnar query execution pipeline
  • #10212 Fix race condition when enabling compression on a hypertable
  • #10230 Batch filtering for compressed DML should respect collation
  • #10254 Direct delete failed to handle array predicates with NULL values and deleted more rows than intended (#10129)
  • #10257 Reuse existing dimension_slice IDs when possible
  • #10265 Truncate constraint name before trying to rename

Thanks

  • @juantxorena for reporting that triggers could not be enabled or disabled on hypertables with columnstore enabled
2026-06-30 19:13:11
timescaledb

2.28.2 (2026-06-30)

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

Bugfixes

  • #10126 Fix bgw_job_stat_history migration for 2.28.1
  • #10133 Fix chunk_constraint migration
  • #10137 Fix column ordering on first/last-based sparse indexes
  • #10164 Automatically drop incompatible smallint bloom filters when upgrading instead of stopping the upgrade

Thanks

  • @juantxorena for reporting an issue with update script for 2.28.1
  • @rusha1333 for reporting an issue when upgrading to 2.28.1