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_ERRORignore - #10855 Enforce
REJECT_LIMITduringCOPY FROMon 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/DELETEon hypertables silently skipping rows underREAD COMMITTED - #10919 Check schema
CREATEprivilege when creating a continuous aggregate - #10925 Create chunk constraints without switching to the catalog owner
- #10961 Fix crash in
decompress_chunkwhen 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_chunkwhen a concurrent decompress or compression change commits - #10962 Reset
search_pathafter everyCOMMITin the columnstore policy - #10964 Fix crash in
cagg_validate_querywhen called with aSELECT INTOstatement - #10964 Fix crash in
cagg_validate_querywhen the user lacksSELECTpermission on the hypertable - #10965 Verify the server certificate on telemetry SSL connections
- #10967 Fix crash in
show_policieswhen called more than once in the same query - #10968 Fix crash in
add_policiesandalter_policieswhen adrop_created_beforeretention policy exists on the hypertable or the continuous aggregate - #10970 Fix
ORDER BYpushdown for realtime continuous aggregates with anORDER BYin 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_functioncompression_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/DELETEregression and bisecting it to2.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
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
UPDATEandDELETEqueries 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.0release.
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_columnarscantotimescaledb.debug_enable_columnarscanto 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
ALTERandDROPoperations 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
UPDATEandDELETE - #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_levelto control continuous aggregate refresh statistics - #10770 Answer eligible
LIMIT 1queries 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
COPYcrash when pgAudit is enabled - #10454 Make
SkipScanuse 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
DeferredChunkAppenddeparse 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()andlast()aggregates - #10639 Report rows moved to the columnstore clearly
- #10651 Avoid evaluating expressions over
GROUP BYcolumns 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 allowcompress_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
ChunkAppendsegfault when parameterized clauses are removed from every chunk - #10765 Allow negative day offsets for the
datevariant oftime_bucket() - #10778 Do not use
SkipScanbelow 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
Gatherduring chunkwise aggregation - #10808 Speed up chunk creation in databases with many constraints
- #10817 Fix
DeferredChunkAppendplanning chunk queries with a restrictedsearch_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_chunkrouting 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 areoff(the default),summary, andverbose_log.timescaledb.enable_aic_compression: enables the experimental Adaptive Integer Compressor. Off by default.timescaledb.enable_columnarscan_metadata_only: answers eligibleLIMIT 1queries on compressed chunks from batch metadata. On by default.timescaledb.move_to_columnstore_tuple_sort_limit: limits how many tuplesmove_to_columnstore()sorts at once to bound memory usage. Defaults to 0 for no limit.
Thanks
- @AdrianAcala for fixing a crash with hypertable
COPYwhen 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
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 CASCADEleaving 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 ASquery selecting from a compressed hypertable
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 CONFLICTwith multiple unique constraints - #10583 Fix
NULLconflict resolution on single-column bloom filtering - #10592 Fix duplicate rows from
DeferredChunkAppendwhenLIMITis not pushed down - #10593 Fix
cannot cast type cstringerror inDeferredChunkAppendqueries
Thanks
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
- https://github.com/timescale/timescaledb/pull/10147 Support segmentwise batch sorted merge for overlapping batches
- https://github.com/timescale/timescaledb/pull/10292 Add
DeferredChunkAppendcustom scan - https://github.com/timescale/timescaledb/pull/10354 Adds DML support for concurrent compaction
- https://github.com/timescale/timescaledb/pull/10388 Add custom toaster for compression
Bugfixes
- https://github.com/timescale/timescaledb/issues/10058 Apply new sortkeys for in-memory recompression
- https://github.com/timescale/timescaledb/pull/10128 Include hypertable chunks in publications created with
FOR TABLES IN SCHEMA - https://github.com/timescale/timescaledb/issues/10325 Avoid test errors when building from a source archive without a git repository
- https://github.com/timescale/timescaledb/pull/10408 Verify columns and their types in
create_compressed_chunk - https://github.com/timescale/timescaledb/pull/10515 Fix row level security checks after dropping hypertable columns
- https://github.com/timescale/timescaledb/issues/9905 Potentially incorrect result of a join when the join clause contains
time_bucket - https://github.com/timescale/timescaledb/issues/9920 Fix the "XX000: failed to evaluate runtime constant in vectorized filter" error in some queries that use stable functions in
WHEREclause and the columnar aggregation pipeline - https://github.com/timescale/timescaledb/pull/10499 Potentially wrong query result when hypertable chunks are filtered out at query run time, the filter condition uses an uncorrelated subquery, and the query uses a parallel execution plan
- https://github.com/timescale/timescaledb/pull/10513 Remove
user_catalog_tableoption from catalog tables - https://github.com/timescale/timescaledb/pull/10506 Correctly match
NULLtuples to compressed batches withNULLboundaries during recompression - https://github.com/timescale/timescaledb/pull/10524 Shared memory leak in the chunk stats subsystem when databases are dropped
- https://github.com/timescale/timescaledb/pull/10535 Fix chunk merging with default sparse indexes
- https://github.com/timescale/timescaledb/pull/10536 Skip batch size check when direct compress is set as hypertable option
- https://github.com/timescale/timescaledb/pull/10539 Allow deletes from the policy chunk stats table when the database publishes all tables
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
- @tureba for reporting the problem with building from a source archive without a git repository https://github.com/timescale/timescaledb/issues/10325
- @AlexFavre for reporting a failed extension update when a publication for all tables exists https://github.com/timescale/timescaledb/issues/10477
- @peterecofit for reporting potentially wrong query result when hypertable chunks are filtered out at query run time https://github.com/timescale/timescaledb/issues/10503
- @esdanieljaegers for reporting the issue and providing steps for reproduction https://github.com/timescale/timescaledb/issues/10511
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_bucketcausing SQLSTATEXX000 - #10363 Fix
time_bucket_gapfill()with window aggregates over constants - #10416 Repair mismatched dimensional
CHECKconstraints - #10423 Fix compressed
SkipScandropping uncompressed rows when sort keys do not match distinct keys - #10430 Do not attach
SkipScanto mismatchedIndexScanpaths underMergeAppend - #9921 Fix wrong results for
IS NULLpredicates with min/max sparse-index pushdown
Thanks
- @borisborelly for reporting incorrect results with
COUNT(DISTINCT)due toSkipScandropping uncompressed rows.
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 isNULL - #10339 Fix crash when deleting from a compressed continuous aggregate source
- #10340 Validate
max_batchesincompact_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
MERGEsupport 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
NULLhandling inadd_dimension() - @igor2x for reporting a typo in a
MERGEsupport error message - @mdisec for reporting issues with compressed data validation during decompression
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
UPDATEandDELETEstatements 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
LIMITclauses). 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
DMLoperations 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
LIMITby switching to row-by-row query execution pipeline - #9917 Decompress less data in
DMLon compressed hypertables by accounting for prepared statement parameters - #9957 Add
compact_chunk()function - #10048 Support concurrent refresh policies on hierarchical continuous aggregates
- #10081 Add
samplerateargument 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
INSERTqueries 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_mergeparameter toalter_job()for mergingjsonbinto the existing job configuration - #10226 Add
recompress_unorderedcolumnstore policy option - #10231 Use
regclassfor storing relation reference in chunk table - #10237 Add helper functions for decoding hypertable status
- #10240 Add the
tsdb.direct_compressstorage parameter that allows enabling direct compress for a given hypertable independent of global settings - #10266 Add
max_batchestocompact_chunk() - #10299 Add
continuous_aggs_tenant_trackingandhypertable_cagg_settingscatalogs
Bugfixes
- #10013 Make ownership error messages on continuous aggregates consistent
- #10052 Result of
MIN/MAXaggregate 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_bucketwith zero width - #10199 Fix
initial_starthandling inbuild_job_info - #10213 Cache sort pathkeys per hypertable
- #10221 Fix incremental refresh skipping the last bucket
- #10278 Drop
job_errorsview inbgw_job_stat_historymigration - #10280
RETURNINGclause returned no rows forINSERTusing 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
INSERTsets it - #10286 Propagate
VACUUMon 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 UPDATEinside 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 forUPDATEandDELETEinstead 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
VACUUMnot 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
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
NULLin 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)andstddev(float8)when used withavg()in the columnar query execution pipeline - #10212 Fix race condition when enabling compression on a hypertable
- #10230 Batch filtering for compressed
DMLshould respect collation - #10254 Direct delete failed to handle array predicates with
NULLvalues and deleted more rows than intended (#10129) - #10257 Reuse existing
dimension_sliceIDs 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
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_historymigration for 2.28.1 - #10133 Fix
chunk_constraintmigration - #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