Tools
TimescaleDB 2.30.0 makes last-point queries constant-time in the number of chunks with a DeferredChunkAppend node
Released 2026-09-08T10:54Z, 2.30.0 adds a DeferredChunkAppend custom scan (#10292) that leaves the hypertable unexpanded during planning and enumerates chunks on demand at execution. Combined with FIRST and LAST sparse index work, this turns "what is the last reading from this sensor" from linear in chunk count to constant when the answer is in the most recent chunk. It is on by default via enable_deferred_chunk_append. The release also fixes potentially wrong results when chunks are runtime-filtered under a parallel plan with an uncorrelated subquery (#10499).
Source
↳ Follow the thread