Skip to content

timescaledb

Relational Databases

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

C Latest 2.27.2 · 1d ago Security brief →

Features

  • PostgreSQL extension for high‑performance time‑series analytics
  • Creates hypertables with automatic columnstore compression
  • Supports real‑time insertion and fast analytical queries

Recent releases

View all 23 releases →
Upgrade now
2.27.2 Bug fix

Crash & result fix

Upgrade now
2.27.1 Security relevant
Auth RBAC

Job errors view leakage fix

Review required
2.27.0 Breaking risk
Breaking upgrade

Drop int2 bloom filter sparse indexes

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

Weekly OSS security release digest.

The CVE patches and breaking changes that affected production tools this week. One email, every Sunday.

No spam, unsubscribe anytime.

About

Stars
22,786
Forks
1,103
Languages
C PLpgSQL Python

Install & Platforms

Install via
shell-script docker
Platforms
linux macos windows

Community & Support

Open source alternatives

Beta — feedback welcome: [email protected]