CVS commit: pkgsrc/databases/postgresql-timescaledb

["Adam Ciarcinski" <adam%netbsd.org@localhost>]

Module Name:    pkgsrc
Committed By:   adam
Date:           Fri Aug  8 09:16:27 UTC 2025

Modified Files:
        pkgsrc/databases/postgresql-timescaledb: Makefile PLIST distinfo

Log Message:
postgresql-timescaledb: updated to 2.21.2

2.21.2 (2025-08-05)

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

**Bugfixes**
* Fix duplicate constraints in JOIN queries
* Fix chunk skipping min/max calculation
* Allow `show_chunks` to process more than 65535 chunks

2.21.1 (2025-07-22)

This release contains one bug fix since the 2.21.0 release. We recommend that you upgrade at the next available opportunity.

**Bugfixes**
* Fix generic plans for foreign key checks and prepared statements

**Thanks**
* @CodeTherapist for reporting the issue with foreign key checks not working after several `INSERT` statements

2.21.0 (2025-07-08)

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

**Highlighted features in TimescaleDB v2.21.0**
* The attach & detach chunks feature allows manually adding or removing chunks from a hypertable with uncompressed chunks, similar to PostgreSQL’s partition management.
* Continued improvement of backfilling into the columnstore, achieving up to 2.5x speedup for constrained tables, by introducing caching logic that boosts throughput for writes to compressed chunks, 
bringing `INSERT` performance close to that of uncompressed chunks.
* Optimized `DELETE` operations on the columstore through batch-level deletions of non-segmentby keys in the filter condition, greatly improving performance to up to 42x faster in some cases, as well 
as reducing bloat, and lowering resource usage.
* The heavy lock taken in Continuous Aggregate refresh was relaxed, enabling concurrent refreshes for non-overlapping ranges and eliminating the need for complex customer workarounds.
* [tech preview] Direct Compress is an innovative TimescaleDB feature that improves high-volume data ingestion by compressing data in memory and writing it directly to disk, reducing I/O overhead, 
eliminating dependency on background compression jobs, and significantly boosting insert performance.

**Sunsetting of the hypercore access method**
We made the decision to deprecate hypercore access method (TAM) with the 2.21.0 release. It was an experiment, which did not show the signals we hoped for and will be sunsetted in TimescaleDB 2.22.0, 
scheduled for September 2025. Upgrading to 2.22.0 and higher will be blocked if TAM is still in use. Since TAM’s inception in [2.18.0](https://github.com/timescale/timescaledb/releases/tag/2.18.0), 
we learned that btrees were not the right architecture. The recent advancements in the columnstore—such as more performant backfilling, SkipScan, adding check constraints, and faster point 
queries—put the [columnstore](https://www.timescale.com/blog/hypercore-a-hybrid-row-storage-engine-for-real-time-analytics) close to or on par with TAM without the storage from the additional index. 
We apologize for the inconvenience this action potentially causes and are here to assist you during the migration process.


To generate a diff of this commit:
cvs rdiff -u -r1.44 -r1.45 pkgsrc/databases/postgresql-timescaledb/Makefile
cvs rdiff -u -r1.40 -r1.41 pkgsrc/databases/postgresql-timescaledb/PLIST
cvs rdiff -u -r1.41 -r1.42 pkgsrc/databases/postgresql-timescaledb/distinfo

Please note that diffs are not public domain; they are subject to the
copyright notices on the relevant files.

Modified files:

Index: pkgsrc/databases/postgresql-timescaledb/Makefile
diff -u pkgsrc/databases/postgresql-timescaledb/Makefile:1.44 pkgsrc/databases/postgresql-timescaledb/Makefile:1.45
--- pkgsrc/databases/postgresql-timescaledb/Makefile:1.44       Wed Jun 11 12:41:24 2025
+++ pkgsrc/databases/postgresql-timescaledb/Makefile    Fri Aug  8 09:16:27 2025
@@ -1,6 +1,6 @@
-# $NetBSD: Makefile,v 1.44 2025/06/11 12:41:24 adam Exp $
+# $NetBSD: Makefile,v 1.45 2025/08/08 09:16:27 adam Exp $
 
-DISTNAME=      timescaledb-2.20.3
+DISTNAME=      timescaledb-2.21.2
 PKGNAME=       postgresql${PGSQL_VERSION}-${DISTNAME}
 CATEGORIES=    databases
 MASTER_SITES=  ${MASTER_SITE_GITHUB:=timescale/}

Index: pkgsrc/databases/postgresql-timescaledb/PLIST
diff -u pkgsrc/databases/postgresql-timescaledb/PLIST:1.40 pkgsrc/databases/postgresql-timescaledb/PLIST:1.41
--- pkgsrc/databases/postgresql-timescaledb/PLIST:1.40  Wed Jun 11 12:41:24 2025
+++ pkgsrc/databases/postgresql-timescaledb/PLIST       Fri Aug  8 09:16:27 2025
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.40 2025/06/11 12:41:24 adam Exp $
+@comment $NetBSD: PLIST,v 1.41 2025/08/08 09:16:27 adam Exp $
 lib/postgresql/timescaledb-${PKGVERSION}.${SHLIB_EXT}
 ${PLIST.tsl}lib/postgresql/timescaledb-tsl-${PKGVERSION}.${SHLIB_EXT}
 lib/postgresql/timescaledb.${SHLIB_EXT}
@@ -37,6 +37,9 @@ share/postgresql/extension/timescaledb--
 share/postgresql/extension/timescaledb--2.20.0--${PKGVERSION}.sql
 share/postgresql/extension/timescaledb--2.20.1--${PKGVERSION}.sql
 share/postgresql/extension/timescaledb--2.20.2--${PKGVERSION}.sql
+share/postgresql/extension/timescaledb--2.20.3--${PKGVERSION}.sql
+share/postgresql/extension/timescaledb--2.21.0--${PKGVERSION}.sql
+share/postgresql/extension/timescaledb--2.21.1--${PKGVERSION}.sql
 share/postgresql/extension/timescaledb--2.9.0--${PKGVERSION}.sql
 share/postgresql/extension/timescaledb--2.9.1--${PKGVERSION}.sql
 share/postgresql/extension/timescaledb--2.9.2--${PKGVERSION}.sql

Index: pkgsrc/databases/postgresql-timescaledb/distinfo
diff -u pkgsrc/databases/postgresql-timescaledb/distinfo:1.41 pkgsrc/databases/postgresql-timescaledb/distinfo:1.42
--- pkgsrc/databases/postgresql-timescaledb/distinfo:1.41       Wed Jun 11 12:41:24 2025
+++ pkgsrc/databases/postgresql-timescaledb/distinfo    Fri Aug  8 09:16:27 2025
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.41 2025/06/11 12:41:24 adam Exp $
+$NetBSD: distinfo,v 1.42 2025/08/08 09:16:27 adam Exp $
 
-BLAKE2s (timescaledb-2.20.3.tar.gz) = b8d464d5209f77d8f54fcc4ac092100939a34e890fd0281c887fc662e89fe1fd
-SHA512 (timescaledb-2.20.3.tar.gz) = 657dd5d5f6583b03a8daccbe9c4432d810614c65700a881ac5e30e0a75d4f07083d1085c71682552fe46e4bb211439b37bbf2b267d41d1ed60744d83776a42b6
-Size (timescaledb-2.20.3.tar.gz) = 7802166 bytes
+BLAKE2s (timescaledb-2.21.2.tar.gz) = 9dd3eee5d3cdce09faa904196d9763c50eb084c6bf0d0246b24a314c0b48a88a
+SHA512 (timescaledb-2.21.2.tar.gz) = a9c1d64f34346e31eab0b358c35d8c9f50918df46e9f29d5452522a34944bc678bd868016a74049ad5660c1b346213b1112abb5c3fe39345d775293b4489d4de
+Size (timescaledb-2.21.2.tar.gz) = 7912251 bytes