# TimescaleDB 2.29.0 — 2.29.0 (2026-07-28) - Product: TimescaleDB (https://whatsnew.fyi/product/timescaledb) - Vendor: Timescale - Date: 2026-07-28 - Version: 2.29.0 - Original notes: https://github.com/timescale/timescaledb/releases/tag/2.29.0 - Permalink: https://whatsnew.fyi/product/timescaledb/releases/2.29.0 What's New is an index, not a publisher: every entry below links to the vendor's own release notes, which are the authoritative source. Entries are labelled where they are hand-curated sample data, pre-releases, or drawn from a secondary source such as a developer blog. Reuse: release facts (products, versions, dates, links, CVE ids and flags) are open data under CC BY 4.0, from the API at https://whatsnew.fyi/api/v1 or the nightly dataset at https://github.com/whatsnew-fyi/dataset. The summaries, labels and curation are © What's New: quote freely with attribution and a link back; wholesale republication of them is not permitted — terms: https://whatsnew.fyi/terms. The vendors' own release notes remain their publishers'. --- Changes to check: - **Requirement raised:** `PostgreSQL 15` → `PostgreSQL 16` (inferred by a model) - **removed** — Remove support for PostgreSQL 15 - **changed** — Speed up DML operations on hypertables by using optimized TimescaleDB hypertable expansion code instead of generic PostgreSQL inheritance hierarchy expansion - **changed** — Speed up expression evaluation in the columnar pipeline by caching common subexpressions - **added** — Add _timescaledb_functions.decompress_batch() SQL function - **changed** — Speed up some queries with small LIMIT by switching to row-by-row query execution pipeline - **changed** — Decompress less data in DML on compressed hypertables by accounting for prepared statement parameters - **added** — Add compact_chunk() function - **added** — Support concurrent refresh policies on hierarchical continuous aggregates - **added** — Add samplerate argument to _timescaledb_functions.estimate_uncompressed_size() - **changed** — Skip classifying compressed relations to speed up planning - **changed** — Don't track compressed relations as separate chunk - **changed** — Reduce memory usage of INSERT queries using direct compress and spanning multiple chunks - **added** — Add a compaction policy for unordered chunks - **changed** — Don't create separate hypertable catalog entry for hypertables with compression - **added** — Add config_merge parameter to alter_job() for merging jsonb into the existing job configuration - **added** — Add recompress_unordered columnstore policy option - **changed** — Use regclass for storing relation reference in chunk table - **added** — Add helper functions for decoding hypertable status - **added** — Add tsdb.direct_compress storage parameter that allows enabling direct compress for a given hypertable independent of global settings 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 improves the performance of `UPDATE` and `DELETE` statements on hypertables. By acquiring row exclusive locks only on the specific chunks being modified rather than the entire hypertable. This enhancement reduces lock contention in high-concurrency workloads involving DML, speeding up the planning of DML queries by using the optimized TimescaleDB chunk exclusion instead of the baseline Postgres constraint exclusion. * The query planner can now choose an additional algorithm for retrieving a small number of rows, for reading the columnstore data, optimizing the default behavior. This optimization improves some last-point queries on columnstore (think `ORDER BY time DESC LIMIT 1`) run several times faster than in previous releases. **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](https://github.com/timescale/timescaledb/pull/10041) Remove support for PostgreSQL 15 **Features** * [#9315](https://github.com/timescale/timescaledb/pull/9315) Speed up `DML` operations on hypertables by using the optimized TimescaleDB hypertable expansion code instead of the generic PostgreSQL inheritance hierarchy expansion * [#9534](https://github.com/timescale/timescaledb/pull/9534) Speed up expression evaluation in the columnar pipeline by caching common subexpressions * [#9684](https://github.com/timescale/timescaledb/pull/9684) Add `_timescaledb_functions.decompress_batch()` SQL function * [#9732](https://github.com/timescale/timescaledb/pull/9732) Speed up some queries with small `LIMIT` by switching to row-by-row query execution pipeline * [#9917](https://github.com/timescale/timescaledb/pull/9917) Decompress less data in `DML` on compressed hypertables by accounting for prepared statement parameters * [#9957](https://github.com/timescale/timescaledb/pull/9957) Add `compact_chunk()` function * [#10048](https://github.com/timescale/timescaledb/pull/10048) Support concurrent refresh policies on hierarchical continuous aggregates * [#10081](https://github.com/timescale/timescaledb/pull/10081) Add `samplerate` argument to `_timescaledb_functions.estimate_uncompressed_size()` * [#10100](https://github.com/timescale/timescaledb/pull/10100) Skip classifying compressed relations to speed up planning * [#10118](https://github.com/timescale/timescaledb/pull/10118) Don't track compressed relations as separate chunk * [#10119](https://github.com/timescale/timescaledb/pull/10119) Reduce memory usage of `INSERT` queries using direct compress and spanning multiple chunks * [#10163](https://github.com/timescale/timescaledb/pull/10163) Add a compaction policy for unordered chunks * [#10204](https://github.com/timescale/timescaledb/pull/10204) Don't create separate hypertable catalog entry for hypertables with compression * [#10217](https://github.com/timescale/timescaledb/pull/10217) Initial placeholder version of granular refresh API * [#10225](https://github.com/timescale/timescaledb/pull/10225) Add `config_merge` parameter to `alter_job()` for merging `jsonb` into the existing job configuration * [#10226](https://github.com/timescale/timescaledb/pull/10226) Add `recompress_unordered` columnstore policy option * [#10231](https://github.com/timescale/timescaledb/pull/10231) Use `regclass` for storing relation reference in chunk table * [#10237](https://github.com/timescale/timescaledb/pull/10237) Add helper functions for decoding hypertable status * [#10240](https://github.com/timescale/timescaledb/pull/10240) Add the `tsdb.direct_compress` storage parameter that allows enablin _[Truncated at 4000 characters — full notes: https://github.com/timescale/timescaledb/releases/tag/2.29.0]_