Skip to content

Release history

timescaledb releases

A time-series database for high-performance real-time analytics packaged as a Postgres extension

Back to tool Latest release

All releases

23 shown

Upgrade now
2.27.2 Bug fix

Crash & result fix

Open
Upgrade now
2.27.1 Security relevant
Auth RBAC

Job errors view leakage fix

Open
Review required
2.27.0 Breaking risk
Breaking upgrade

Drop int2 bloom filter sparse indexes

Open
2.26.4 Bug fix

Minor fixes and improvements.

Full changelog

This release contains bug fixes since the 2.26.3 release. We recommend that you upgrade at the next available opportunity.

Bugfixes

  • #9360 Sanitize DT_NOBEGIN next_start to recover jobs stuck after primary failover
  • #9515 Fix now() constification for continuous aggregate queries
  • #9550 Fix out of memory when propagating ALTER TABLE to many chunks
  • #9605 Fix InstrStartNode called twice in a row
  • #9607 Fix use-after-free of PlaceHolderVar.phrels in cached ChunkAppend plans
  • #9612 Fix PlaceHolderVar error in runtime chunk exclusion
  • #9614 Remove stale hypertable entries during upgrade
  • #9615 Fix segfault with transition tables after column drop
  • #9616 Use DROP CASCADE for trigger removal
  • #9623 Error when querying compressed chunks under Apache license
  • #9625 Make timescaledb_post_restore() reliably restart background workers in a single call
  • #9639 Fix lost orderby sparse index
  • #9646 Replace ERRCODE_INTERNAL_ERROR on user-reachable error paths
  • #9652 Add Error on missing custom job function in ts_bgw_job_get_funci
  • #9655 Fix data corruption when merging chunks with different compression settings
  • #9654 Fix sort_transform crash with hypertable on nullable side of outer join
  • #9656 Fix concurrent merge of compressed chunks dropping the new heap
  • #9641 Fix COPY path with transition tables after column drop
  • #9660 Fix incremental continuous aggregate refresh so that extend_last_bucket only applies to the boundary batch
  • #9674 Fix segmentby crash in cagg invalidation tracking

Thanks

  • @GetsuDer and @WeiJie-JL for reporting an error with timescaledb and extensions using Explain
  • @igor2x for reporting a problem when trying to query compressed data with the Apache license
  • @ivaaaan for reporting an issue with constraint pushdown in continuous aggregate queries
  • @patstrom for reporting a segfault with transition table triggers after dropping a column
  • @patstrom for reporting an out-of-memory error when dropping constraints
  • @pcayen for reporting an issue with GROUP BY ROLLUP on views over hypertables
View release on GitHub
2.26.2 Bug fix

Use-after-free bugs fixed in compressor and job handling, plus chunk and continuous aggregate corrections.

View release on GitHub
2.26.0 New feature
Notable features
  • Vectorized aggregation evaluates functions directly on columnar data
  • Composite bloom filters for SELECT/UPSERT with 2x faster queries
  • ColumnarIndexScan custom node with up to 70x improvement
View release on GitHub
2.25.2 Security relevant
Security fixes
  • GHSA-vgp2-jj5c-828m - search_path vulnerability in SQL scripts
View release on GitHub
2.25.1 Bug fix

Performance improvements and bug fixes for continuous aggregates, bloom filters, and queries.

View release on GitHub
2.25.0 Breaking risk
Breaking changes
  • Old continuous aggregate format removed - users must migrate to new format
Notable features
  • Direct compress during continuous aggregate refresh
  • Delete optimizations for continuous aggregates
  • Improved segmentby and orderby defaults
View release on GitHub
2.24.0 Breaking risk
Breaking changes
  • Bloom filter sparse indexes will stop working and require decompression/recompression to re-enable
Notable features
  • Direct Compress works with continuous aggregates
  • In-memory recompression 4-5x faster
  • UUIDv7 in time_bucket for continuous aggregates
View release on GitHub
2.23.1 Bug fix

Fixes crash in policy creation and addresses bugs in continuous aggregates and UUID decoding.

View release on GitHub
2.23.0 New feature
Notable features
  • PostgreSQL 18 full support
  • UUIDv7 compression enabled by default
  • Unlogged hypertables support
View release on GitHub
2.22.1 Breaking risk
Breaking changes
  • Concurrent refresh policy creation blocked for hierarchical continuous aggregates due to deadlock risk
View release on GitHub
2.21.4 Bugfix

Fixes wrong selectivity estimates in Postgres 15.14, 16.10, 17.6; includes performance improvements.

View release on GitHub
2.22.0 Breaking risk
Breaking changes
  • Hypercore table access method removed - affected tables must be converted to heap access method
Notable features
  • Sparse indexes configurable via ALTER TABLE
  • UUIDv7 compression with vectorization support
  • Hypertables partitionable by UUIDv7
View release on GitHub
2.21.1 Bug fix

Fixes a bug in generic plans affecting foreign key checks and prepared statements.

View release on GitHub
2.21.0 New feature
Notable features
  • Attach/detach chunks for manual partition management on hypertables
  • Concurrent continuous aggregate refreshes with relaxed locking for non-overlapping ranges
  • Optimized DELETE on non-segmentby columns in columnstore (up to 42x faster)
View release on GitHub

Beta — feedback welcome: [email protected]