timescaledb

v2.28.1 Bugfix

This release fixes issues for SREs watching stability and regressions.

Published 1mo Relational Databases

View tool

✓ 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/9913, https://github.com/timescale/timescaledb/pull/10091, and https://github.com/timescale/timescaledb/pull/10056 across a mixed release.

Full changelog

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

Bugfixes

#9913 Fix potential crash on DML on compressed tables when the plan uses Bitmap Heap Scan
#10091 Fix column rename for compressed chunks
#10056 Enforce CHECK, NOT NULL and view WITH CHECK OPTION constraints for direct compress inserts
#10059 Fix error when using first/last aggregates in a HAVING clause
#10060 Fix first/last optimization returning the same value for aggregates that share the value column but order by different columns
#10061 Fix internal error in first/last for unsortable types
#10069 Fix bgw_job_stat_history definition
#10073 Fix uncompressed size estimate for varlen
#10089 Fix deleting every row on compressed hypertable with subquery returning constant false
#10094 Fix use-after-free in ALTER TABLE ADD CONSTRAINT

Thanks

@skrenes for reporting a problem with the job_history view when upgrading to 2.28.0

View diff on GitHub

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

Share on X Share on Bluesky

Track timescaledb

Get notified when new releases ship.

About timescaledb

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

All releases →

Related context

Related tools

Earlier breaking changes

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