timescaledb version history

- Fix `bgw_job_stat_history` and `chunk_constraint` migrations - Fix column ordering on sparse indexes - Automatically drop incompatible smallint bloom filters during upgrade - Address reported upgrade issues from 2.28.1

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](https://github.com/timescale/timescaledb/pull/9913) Fix potential crash on `DML` on compressed tables when the plan uses `Bitmap Heap Scan` * [#10091](https://github.com/timescale/timescaledb/pull/10091) Fix column rename for compressed chunks * [#10056](https://github.com/timescale/timescaledb/pull/10056) Enforce `CHECK`, `NOT NULL` and view `WITH CHECK OPTION` constraints for direct compress inserts * [#10059](https://github.com/timescale/timescaledb/pull/10059) Fix error when using `first`/`last` aggregates in a `HAVING` clause * [#10060](https://github.com/timescale/timescaledb/pull/10060) Fix `first`/`last` optimization returning the same value for aggregates that share the value column but order by different columns * [#10061](https://github.com/timescale/timescaledb/pull/10061) Fix internal error in `first`/`last` for unsortable types * [#10069](https://github.com/timescale/timescaledb/pull/10069) Fix `bgw_job_stat_history` definition * [#10073](https://github.com/timescale/timescaledb/pull/1

This release contains performance improvements and bug fixes since the 2.27.2 release. We recommend that you upgrade at the next available opportunity. **Highlighted features in TimescaleDB v2.28.0** * **Faster `first()` and `last()` queries on compressed data.** TimescaleDB derives `first(value, time)` and `last(value, time)` aggregates straight from the columnstore's batch metadata, skipping batch decompression entirely. For the "latest reading per series" lookups that time-series workloads run constantly, that means meaningfully faster recency queries with no changes to your SQL queries. * **Lighter, less disruptive continuous aggregate refreshes.** `refresh_continuous_aggregate()` can now run incrementally in batches — the same behavior refresh policies already use — enabling breaking large manual refreshes into smaller chunks (tunable via `buckets_per_batch`, `max_batches_per_execution`, and `refresh_newest_first`) instead of one heavy operation. Refreshes also now take a lighter lock while processing the invalidation log, so they no longer block unrelated concurrent operations on the same continuous aggregate, improving behavior for concurrent workloads. * **Vectorized

This release contains bug fixes since the 2.27.1 release. We recommend that you upgrade at the next available opportunity. **Bugfixes** * [#9895](https://github.com/timescale/timescaledb/pull/9895) Remove refresh policy check when adding columnstore policy * [#9902](https://github.com/timescale/timescaledb/pull/9902) Fix wrong results and crashes when grouping by columns that are not in the `SELECT` list with vectorized aggregation or columnar index scan * [#9908](https://github.com/timescale/timescaledb/pull/9908) Skip `ColumnarIndexScan` when the qual contains a SubPlan

# TimescaleDB Changelog **Please note: When updating your database, you should connect using `psql` with the `-X` flag to prevent any `.psqlrc` commands from accidentally triggering the load of a previous DB version.** This release contains performance improvements and bug fixes since the 2.27.0 release. We recommend that you upgrade at the next available opportunity. **Bugfixes** * [#9795](https://github.com/timescale/timescaledb/pull/9795) Delete orphaned `compression_settings` before migrating catalog table * [#9799](https://github.com/timescale/timescaledb/pull/9799) Fix `job_errors` view leaking failed jobs to non-owners * [#9800](https://github.com/timescale/timescaledb/pull/9800) Check hypertable ownership before recompression * [#9801](https://github.com/timescale/timescaledb/pull/9801) Fix information leak in `policy_reorder_remove` * [#9824](https://github.com/timescale/timescaledb/pull/9824) Adding migration scripts for composite bloom filters * [#9828](https://github.com/timescale/timescaledb/pull/9828) Skip columnar index scan when grouping by an expression * [#9830](https://github.com/timescale/timescaledb/pull/9830) Skip `ColumnarIndexScan` for GROU

This release contains performance improvements and bug fixes since the 2.26.4 release. We recommend that you upgrade at the next available opportunity. ⚠️ Due to a problem during release process the Window's releases artifacts attached to this release are not valid. Download valid Windows binaries from: * [TimescaleDB Windows PG15](https://database-eng-exceptional-releases.s3.amazonaws.com/2.27.0/timescaledb-postgresql-15-windows-amd64.zip ) * [TimescaleDB Windows PG16](https://database-eng-exceptional-releases.s3.amazonaws.com/2.27.0/timescaledb-postgresql-16-windows-amd64.zip ) * [TimescaleDB Windows PG17](https://database-eng-exceptional-releases.s3.amazonaws.com/2.27.0/timescaledb-postgresql-17-windows-amd64.zip) * [TimescaleDB Windows PG18](https://database-eng-exceptional-releases.s3.amazonaws.com/2.27.0/timescaledb-postgresql-18-windows-amd64.zip) **Highlighted features in TimescaleDB v2.27.0** * The Hypercore engine now supports a vectorized implementation of filters by evaluating them inline through the standard Postgres function path. This expands the set of queries (including continuous aggregate refreshes) that can take the faster path through the column

This release contains bug fixes since the 2.26.3 release. We recommend that you upgrade at the next available opportunity. **Bugfixes** * [#9360](https://github.com/timescale/timescaledb/pull/9360) Sanitize `DT_NOBEGIN` next_start to recover jobs stuck after primary failover * [#9515](https://github.com/timescale/timescaledb/pull/9515) Fix `now()` constification for continuous aggregate queries * [#9550](https://github.com/timescale/timescaledb/pull/9550) Fix out of memory when propagating `ALTER TABLE` to many chunks * [#9605](https://github.com/timescale/timescaledb/pull/9605) Fix `InstrStartNode` called twice in a row * [#9607](https://github.com/timescale/timescaledb/pull/9607) Fix use-after-free of `PlaceHolderVar.phrels` in cached ChunkAppend plans * [#9612](https://github.com/timescale/timescaledb/pull/9612) Fix `PlaceHolderVar` error in runtime chunk exclusion * [#9614](https://github.com/timescale/timescaledb/pull/9614) Remove stale hypertable entries during upgrade * [#9615](https://github.com/timescale/timescaledb/pull/9615) Fix segfault with transition tables after column drop * [#9616](https://github.com/timescale/timescaledb/pull/9616) Use `DROP CASCADE` f

This release contains bug fixes since the 2.26.2 release. We recommend that you upgrade at the next available opportunity. **Bugfixes** * [#9511](https://github.com/timescale/timescaledb/pull/9511) Fix `alter_job` failing for retention policy with `drop_created_before` argument * [#9557](https://github.com/timescale/timescaledb/pull/9557) Clean up orphaned `compression_chunk_size` entries during the extension upgrade * [#9551](https://github.com/timescale/timescaledb/pull/9551) Fix resource leaks on error paths for during a continuous aggregate refresh * [#9563](https://github.com/timescale/timescaledb/pull/9563) Fix gapfill out-of-order bucket creation during DST shift * [#9571](https://github.com/timescale/timescaledb/pull/9571) Fix concurrent refreshes of continuous aggregates **Thanks** * @sebastian-ederer for reporting an issue with alter_job and drop_created_before * @petergledhillinclusive for reporting the DST shift issue with time_bucket_gapfill * @GTan615 for reporting the data duplicate issues observed during overlapping cagg refreshes

This release contains bug fixes since the 2.26.1 release. We recommend that you upgrade at the next available opportunity. **Bugfixes** * [#9460](https://github.com/timescale/timescaledb/pull/9460) Fix WAL record tracking in `EXPLAIN` for direct compress * [#9485](https://github.com/timescale/timescaledb/pull/9485) Fix use-after-free of invalidation in `tsl_compressor_free` * [#9486](https://github.com/timescale/timescaledb/pull/9486) Fix use-after-free in job owner validation * [#9487](https://github.com/timescale/timescaledb/pull/9487) Fix use-after-free in `reorder_chunk` * [#9392](https://github.com/timescale/timescaledb/pull/9392) Fix wrong result when performing chunk exclusion by a mutable expression * [#9510](https://github.com/timescale/timescaledb/pull/9510) Fix chunk skipping with dropped columns * [#9522](https://github.com/timescale/timescaledb/pull/9522) Fix `GROUP BY ROLLUP` on compressed continuous aggregates **Thanks** * @pcayen for reporting an issue with GROUP BY ROLLUP * @PiotrCiechomski for reporting the wrong result with chunk exclusion by a mutable expression

This release contains bug fixes since the 2.26.0 release. We recommend that you upgrade at the next available opportunity. **Bugfixes** * [#9455](https://github.com/timescale/timescaledb/pull/9455) Fix memory leak in ColumnarScan Exceptionally, this windows' release binaries are available here: - [TimescaleDB Windows PG15](https://database-eng-exceptional-releases.s3.amazonaws.com/2.26.1/TimescaleDB_Windows_PG15.zip) - [TimescaleDB Windows PG16](https://database-eng-exceptional-releases.s3.amazonaws.com/2.26.1/TimescaleDB_Windows_PG16.zip) - [TimescaleDB Windows PG17](https://database-eng-exceptional-releases.s3.amazonaws.com/2.26.1/TimescaleDB_Windows_PG17.zip) - [TimescaleDB Windows PG18](https://database-eng-exceptional-releases.s3.amazonaws.com/2.26.1/TimescaleDB_Windows_PG18.zip)