2.30.0
2.30.0 (2026-09-08)
Added 6
- Support segmentwise batch sorted merge for overlapping batches
- Add DeferredChunkAppend custom scan node that reduces planning overhead by delaying chunk expansion until execution
- Add DML support for concurrent compaction
- Add custom toaster for compression
- Add enable_deferred_chunk_append GUC to control custom scan node for hypertables
- Add use_custom_toaster GUC to use custom TOAST writer for compressed row inserts
Fixed 14
- Apply new sortkeys for in-memory recompression
- Include hypertable chunks in publications created with FOR TABLES IN SCHEMA
- Avoid test errors when building from a source archive without a git repository
- Verify columns and their types in create_compressed_chunk
- Fix row level security checks after dropping hypertable columns
- Fix potentially incorrect result of a join when the join clause contains time_bucket
- Fix the XX000: failed to evaluate runtime constant in vectorized filter error in some queries that use stable functions in WHERE clause and the columnar aggregation pipeline
- Fix 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
- Remove user_catalog_table option from catalog tables
- Correctly match NULL tuples to compressed batches with NULL boundaries during recompression
- Fix shared memory leak in the chunk stats subsystem when databases are dropped
- Fix chunk merging with default sparse indexes
- Skip batch size check when direct compress is set as hypertable option
- Allow deletes from the policy chunk stats table when the database publishes all tables
From TimescaleDB
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