LoginSign Up
← Back to all sparks
T

TimescaleDB

ANALYTICS
Velocity5.0

Time-series database built on PostgreSQL

www.timescale.com ↗

TimescaleDB 2.30 cuts LIMIT query planning time with a new DeferredChunkAppend node.

time-series-dbpostgresql-extensionquery-performancecompressionself-hosted
◆Current state
TimescaleDB is in a steady incremental release cycle, shipping monthly point releases focused on query performance and correctness. v2.30.0 introduces DeferredChunkAppend, a custom query plan node that delays chunk expansion during planning to speed up LIMIT queries on large hypertables. The surrounding releases (2.29.0–2.29.2) addressed DML chunk exclusion, security patches, and standard bug fixes.
◆Where it's heading
The pattern over this period is consistent: each minor release targets a specific query-path bottleneck (DML chunk exclusion in 2.29, LIMIT planning in 2.30) rather than feature additions. This is optimization-first development, appropriate for a mature time-series extension where users hit performance walls before they hit feature gaps. No architectural pivots visible in the recent entries.
◆Prediction
Expect the next cycle (2.31 or 2.30.x) to continue this bottleneck-by-bottleneck approach; aggregation paths on compressed chunks are a likely target based on the pattern of prior releases.

◆Recent moves

  1. 7d ago

    TimescaleDB 2.30.0: DeferredChunkAppend speeds up LIMIT queries

    v2.30.0's DeferredChunkAppend node delays chunk expansion at plan time for LIMIT queries, a meaningful speedup for workloads that issue LIMIT on large hypertables. This is a targeted planner improvement, not an architectural change.

    View source ↗
  2. 28d ago

    2.29.2 (2026-08-18)

    2.29.2 is a bugfix-only patch addressing edge cases in time_bucket, gapfill window aggregates, and dimensional CHECK constraints — correctness fixes the typical user won't encounter.

    View source ↗
  3. 1mo ago

    2.29.1 (2026-08-04)

    2.29.1 patches security vulnerabilities alongside routine bug fixes — mandatory for production deployments but no user-visible changes otherwise.

    View source ↗
  4. 1mo ago

    TimescaleDB 2.29.0: DML chunk exclusion for faster UPDATE and DELETE

    v2.29.0 adds chunk exclusion for DML operations so UPDATE and DELETE statements acquire row-exclusive locks only on the relevant chunk, not the entire hypertable. A meaningful write performance improvement for large-partition workloads.

    View source ↗
  5. 2mo ago

    2.28.3 (2026-07-16)

    2.28.3 fixes a wrong-result bug in the columnar query execution pipeline and sort transformation edge cases — correctness patches with no new capabilities.

    View source ↗
  6. 2mo ago

    2.28.2 (2026-06-30)

    2.28.2 is a migration and constraint fix release following 2.28.1's broader changes — standard housekeeping patch.

    View source ↗