This release contains performance improvements and bug fixes since the 2.30.2 release. We recommend that you upgrade at the next available opportunity. Highlighted features in TimescaleDB v2.31.0 Improved performance for UPDATE and DELETE queries on the columnstore with vectorized key processing for bulk decompression. The vectorized aggregation makes DML and recompression operations faster throug…
This release contains bug fixes since the 2.30.1 release. We recommend that you upgrade at the next available opportunity. Bugfixes #10665 Fix crash when merging chunks with different column layouts #10668 Fix DROP SCHEMA CASCADE leaving orphaned compressed chunks #10682 Fix vectorized text comparison ignoring a non-deterministic collation given in the query #10609 Fix race while updating granular…
This release contains bug fixes since the 2.30.0 release. We recommend that you upgrade at the next available opportunity. Bugfixes #10580 Fix missing conflicts for INSERT ... ON CONFLICT with multiple unique constraints #10583 Fix NULL conflict resolution on single-column bloom filtering #10592 Fix duplicate rows from DeferredChunkAppend when LIMIT is not pushed down #10593 Fix cannot cast type c…
This release contains performance improvements and bug fixes since the 2.29.2 release. We recommend that you upgrade at the next available opportunity. Highlighted features in TimescaleDB v2.30.0 Blazing fast LIMIT queries with the newly introduced DeferredChunkAppend. This custom node reduces planning significantly by delaying chunk expansion. During planning the hypertable stays unexpanded and o…
This release contains bug fixes since the 2.29.1 release. We recommend that you upgrade at the next available opportunity. Bugfixes #10189 Fix user-defined functions named time_bucket causing SQLSTATE XX000 #10363 Fix time_bucket_gapfill() with window aggregates over constants #10416 Repair mismatched dimensional CHECK constraints #10423 Fix compressed SkipScan dropping uncompressed rows when sort…
This release contains performance improvements and bug fixes since the 2.29.0 release and fixes for security vulnerabilities (#10360, #10379, #10386). You can check the security advisory for more information on the vulnerability and the platforms that are affected. We recommend that you upgrade at the next available opportunity. Bugfixes #10327 Assertion failure in add_dimension() when the hyperta…
This release contains performance improvements and bug fixes since the 2.28.3 release. We recommend that you upgrade at the next available opportunity. Release Highlights Chunk exclusion for DML operations improves the performance of UPDATE and DELETE statements on hypertables. By acquiring row exclusive locks only on the specific chunks being modified rather than the entire hypertable. This enhan…
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 t…
This release contains bug fixes since the 2.28.1 release. We recommend that you upgrade at the next available opportunity. Bugfixes #10126 Fix bgw_job_stat_history migration for 2.28.1 #10133 Fix chunk_constraint migration #10137 Fix column ordering on first/last-based sparse indexes #10164 Automatically drop incompatible smallint bloom filters when upgrading instead of stopping the upgrade Thanks…
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 #100…
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 e…
This release contains bug fixes since the 2.27.1 release. We recommend that you upgrade at the next available opportunity. Bugfixes #9895 Remove refresh policy check when adding columnstore policy #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 Skip ColumnarIndexScan when the qual contains a SubPl…
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 Delete orphaned compressio…
2.27.0
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 TimescaleDB Windows PG16 TimescaleDB Windows PG17 TimescaleDB Windows…
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 F…
This release contains bug fixes since the 2.26.2 release. We recommend that you upgrade at the next available opportunity. Bugfixes #9511 Fix alter_job failing for retention policy with drop_created_before argument #9557 Clean up orphaned compression_chunk_size entries during the extension upgrade #9551 Fix resource leaks on error paths for during a continuous aggregate refresh #9563 Fix gapfill o…
This release contains bug fixes since the 2.26.1 release. We recommend that you upgrade at the next available opportunity. Bugfixes #9460 Fix WAL record tracking in EXPLAIN for direct compress #9485 Fix use-after-free of invalidation in tsl_compressor_free #9486 Fix use-after-free in job owner validation #9487 Fix use-after-free in reorder_chunk #9392 Fix wrong result when performing chunk exclusi…