CVS commit: pkgsrc/databases/postgresql-timescaledb

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

Module Name:    pkgsrc
Committed By:   adam
Date:           Fri Apr 17 10:14:09 UTC 2026

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

Log Message:
postgresql-timescaledb: updated to 2.26.3

2.26.3 (2026-04-14)

This release contains bug fixes since the 2.26.2 release. We recommend that you upgrade at the next available opportunity.

2.26.2 (2026-04-07)

This release contains bug fixes since the 2.26.1 release. We recommend that you upgrade at the next available opportunity.

2.26.1 (2026-03-30)

This release contains bug fixes since the 2.26.0 release. We recommend that you upgrade at the next available opportunity.

2.26.0 (2026-03-24)

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

Highlighted features in TimescaleDB v2.26.0

The vectorized aggregation engine now evaluates PostgreSQL functions directly on columnar arguments and stores the results in a columnar format to preserve the high-speed execution pipeline. For 
analytical queries that leverage functions like time_bucket() in grouping or aggregation expressions, the function is evaluated natively without falling back to standard row-based processing. This 
enhancement ensures that the remainder of the query can seamlessly continue using the highly efficient columnar pipeline, yielding performance improvements of 3.5 times faster.
The query execution engine now supports composite bloom filters for SELECT and UPSERT operations, pushing down multi-column predicates directly to compressed table scans. This optimization bypasses 
costly batch decompression by automatically selecting the most restrictive bloom filter to quickly verify if target values are present. Showing over two times faster query performance when a 
composite bloom filter is used. Additionally, query profiling now includes detailed EXPLAIN statistics to monitor batch pruning and false-positive rates.
The custom node ColumnarIndexScan adjusts the query plan to fetch values from the sparse minmax indexes, improving query performance on the columnstore by up to 70x. For analytical queries that 
leverage functions like COUNT, MIN, MAX, FIRST (limited), and LAST (limited), the sparse index is being read instead of decompressing the batch.


To generate a diff of this commit:
cvs rdiff -u -r1.50 -r1.51 pkgsrc/databases/postgresql-timescaledb/Makefile
cvs rdiff -u -r1.46 -r1.47 pkgsrc/databases/postgresql-timescaledb/PLIST
cvs rdiff -u -r1.47 -r1.48 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.50 pkgsrc/databases/postgresql-timescaledb/Makefile:1.51
--- pkgsrc/databases/postgresql-timescaledb/Makefile:1.50       Thu Mar  5 10:38:19 2026
+++ pkgsrc/databases/postgresql-timescaledb/Makefile    Fri Apr 17 10:14:09 2026
@@ -1,6 +1,6 @@
-# $NetBSD: Makefile,v 1.50 2026/03/05 10:38:19 adam Exp $
+# $NetBSD: Makefile,v 1.51 2026/04/17 10:14:09 adam Exp $
 
-DISTNAME=      timescaledb-2.25.2
+DISTNAME=      timescaledb-2.26.3
 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.46 pkgsrc/databases/postgresql-timescaledb/PLIST:1.47
--- pkgsrc/databases/postgresql-timescaledb/PLIST:1.46  Thu Mar  5 10:38:19 2026
+++ pkgsrc/databases/postgresql-timescaledb/PLIST       Fri Apr 17 10:14:09 2026
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.46 2026/03/05 10:38:19 adam Exp $
+@comment $NetBSD: PLIST,v 1.47 2026/04/17 10:14:09 adam Exp $
 lib/postgresql/timescaledb-${PKGVERSION}.${SHLIB_EXT}
 ${PLIST.tsl}lib/postgresql/timescaledb-tsl-${PKGVERSION}.${SHLIB_EXT}
 lib/postgresql/timescaledb.${SHLIB_EXT}
@@ -50,6 +50,10 @@ share/postgresql/extension/timescaledb--
 share/postgresql/extension/timescaledb--2.24.0--${PKGVERSION}.sql
 share/postgresql/extension/timescaledb--2.25.0--${PKGVERSION}.sql
 share/postgresql/extension/timescaledb--2.25.1--${PKGVERSION}.sql
+share/postgresql/extension/timescaledb--2.25.2--${PKGVERSION}.sql
+share/postgresql/extension/timescaledb--2.26.0--${PKGVERSION}.sql
+share/postgresql/extension/timescaledb--2.26.1--${PKGVERSION}.sql
+share/postgresql/extension/timescaledb--2.26.2--${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.47 pkgsrc/databases/postgresql-timescaledb/distinfo:1.48
--- pkgsrc/databases/postgresql-timescaledb/distinfo:1.47       Thu Mar  5 10:38:19 2026
+++ pkgsrc/databases/postgresql-timescaledb/distinfo    Fri Apr 17 10:14:09 2026
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.47 2026/03/05 10:38:19 adam Exp $
+$NetBSD: distinfo,v 1.48 2026/04/17 10:14:09 adam Exp $
 
-BLAKE2s (timescaledb-2.25.2.tar.gz) = e5d45a89164d1a27223a36a1e0783627bd91b90649daef280cb3985e89802665
-SHA512 (timescaledb-2.25.2.tar.gz) = c4a3c6feb49a71dc373fa19316d617c442dfcd94ed2284a9f43bf845dac1a2e6e754dfb50072c80b57e3f986298a25a3d0631b2883465f7b1857f9ee670d36ae
-Size (timescaledb-2.25.2.tar.gz) = 8308761 bytes
+BLAKE2s (timescaledb-2.26.3.tar.gz) = 58a4433e66aea1ee566c735135ddca776ded2dfde34d119f1465db3dc6011041
+SHA512 (timescaledb-2.26.3.tar.gz) = 20995b46216343aee1f26b4f70964e1bdde3a55235ff278fd77d54e4bcf0277930dbe040d23cabeed085b6d1c5ac0e005db68191ad8052765efd0b373626c8c7
+Size (timescaledb-2.26.3.tar.gz) = 8478330 bytes