Skip to content

timescaledb

v2.28.3 Bugfix

This release fixes issues for SREs watching stability and regressions.

Published 10d Relational Databases
✓ No known CVEs patched
Read the diff → Tool health → What is this tool? →

✓ No known CVEs patched in this version

Topics

analytics database financial-analysis iot postgresql sql
+5 more
tigerdata time-series time-series-database timescaledb tsdb

Summary

AI summary

Updates https://github.com/timescale/timescaledb/pull/10082, https://github.com/timescale/timescaledb/pull/10178, and https://github.com/timescale/timescaledb/pull/10179 across a mixed release.

Changes in this release

Feature Medium

Allow enabling and disabling triggers on hypertables with columnstore enabled

Allow enabling and disabling triggers on hypertables with columnstore enabled

Source: llm_adapter@2026-07-16

Confidence: high

Performance Low

Reuse existing dimension_slice IDs when possible to reduce allocation overhead

Reuse existing dimension_slice IDs when possible to reduce allocation overhead

Source: llm_adapter@2026-07-16

Confidence: high

Bugfix Medium

Fix wrong result when evaluating a NULL-returning function in columnar query pipeline

Fix wrong result when evaluating a NULL-returning function in columnar query pipeline

Source: llm_adapter@2026-07-16

Confidence: high

Bugfix Medium

Fix incorrect usage of sort transformation for negative constant sort key expressions

Fix incorrect usage of sort transformation for negative constant sort key expressions

Source: llm_adapter@2026-07-16

Confidence: high

Bugfix Medium

Fix columnstore sort pushdown to account for different query sort key collation

Fix columnstore sort pushdown to account for different query sort key collation

Source: llm_adapter@2026-07-16

Confidence: high

Bugfix Medium

Fix potentially wrong results for stddev(float4) and stddev(float8) when used with avg() in columnar pipeline

Fix potentially wrong results for stddev(float4) and stddev(float8) when used with avg() in columnar pipeline

Source: llm_adapter@2026-07-16

Confidence: high

Bugfix Medium

Fix race condition when enabling compression on a hypertable

Fix race condition when enabling compression on a hypertable

Source: llm_adapter@2026-07-16

Confidence: high

Bugfix Medium

Ensure batch filtering for compressed DML respects collation settings

Ensure batch filtering for compressed DML respects collation settings

Source: llm_adapter@2026-07-16

Confidence: high

Bugfix Medium

Fix direct delete handling of array predicates with NULL values to prevent over‑deletion

Fix direct delete handling of array predicates with NULL values to prevent over‑deletion

Source: llm_adapter@2026-07-16

Confidence: high

Bugfix Low

Truncate constraint name before attempting to rename it

Truncate constraint name before attempting to rename it

Source: llm_adapter@2026-07-16

Confidence: high

Full changelog

This release contains performance improvements and bug fixes since the 2.28.2 release. We recommend that you upgrade at the next available opportunity.

Bugfixes

  • #10082 Wrong result when evaluating a function returning NULL in the columnar query execution pipeline
  • #10178 Fix incorrect usage of sort transformation for sort key expressions with negative constants
  • #10179 Allow enabling and disabling triggers on hypertables with columnstore enabled
  • #10182 Fix columnstore sort pushdown to check for different query sort key collation
  • #10209 Fix potentially wrong results for stddev(float4) and stddev(float8) when used with avg() in the columnar query execution pipeline
  • #10212 Fix race condition when enabling compression on a hypertable
  • #10230 Batch filtering for compressed DML should respect collation
  • #10254 Direct delete failed to handle array predicates with NULL values and deleted more rows than intended (#10129)
  • #10257 Reuse existing dimension_slice IDs when possible
  • #10265 Truncate constraint name before trying to rename

Thanks

  • @juantxorena for reporting that triggers could not be enabled or disabled on hypertables with columnstore enabled

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.

Share this release

Track timescaledb

Get notified when new releases ship.

Sign up free

About timescaledb

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

All releases →

Related context

Earlier breaking changes

  • v2.27.0 Bloom filter sparse indexes on compressed int2 columns may miss matching rows; upgrade requires manual index dropping

Beta — feedback welcome: [email protected]