CVS commit: pkgsrc/databases/postgresql-timescaledb

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

Module Name:    pkgsrc
Committed By:   adam
Date:           Mon Jun 29 19:43:28 UTC 2026

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

Log Message:
postgresql-timescaledb: updated to 2.28.1

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.

2.28.0

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 execution now covers CASE expressions. TimescaleDB's columnar executor can now evaluate CASE ... WHEN expressions directly on compressed data, so queries using conditional logic stay on 
the fast vectorized path instead of falling back to slower row-by-row decompression. This speeds up a common pattern — conditional aggregations and computed columns over compressed history — with no 
query changes needed.
Add new aggregations to a continuous aggregate without rebuilding it. You can now run ALTER MATERIALIZED VIEW <cagg> ADD COLUMN <name> <type> GENERATED ALWAYS AS (<aggregate>) STORED to add a new 
computed aggregate to an existing continuous aggregate in place — no more dropping and recreating the whole aggregate just to track one more metric. New data populates the column going forward, 
letting your rollups evolve alongside your application. (Existing rows start as NULL; a forced refresh backfills them when you need historical values.)


To generate a diff of this commit:
cvs rdiff -u -r1.54 -r1.55 pkgsrc/databases/postgresql-timescaledb/Makefile
cvs rdiff -u -r1.50 -r1.51 pkgsrc/databases/postgresql-timescaledb/PLIST
cvs rdiff -u -r1.51 -r1.52 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.54 pkgsrc/databases/postgresql-timescaledb/Makefile:1.55
--- pkgsrc/databases/postgresql-timescaledb/Makefile:1.54       Wed Jun  3 07:11:30 2026
+++ pkgsrc/databases/postgresql-timescaledb/Makefile    Mon Jun 29 19:43:28 2026
@@ -1,6 +1,6 @@
-# $NetBSD: Makefile,v 1.54 2026/06/03 07:11:30 adam Exp $
+# $NetBSD: Makefile,v 1.55 2026/06/29 19:43:28 adam Exp $
 
-DISTNAME=      timescaledb-2.27.2
+DISTNAME=      timescaledb-2.28.1
 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.50 pkgsrc/databases/postgresql-timescaledb/PLIST:1.51
--- pkgsrc/databases/postgresql-timescaledb/PLIST:1.50  Wed Jun  3 07:11:30 2026
+++ pkgsrc/databases/postgresql-timescaledb/PLIST       Mon Jun 29 19:43:28 2026
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.50 2026/06/03 07:11:30 adam Exp $
+@comment $NetBSD: PLIST,v 1.51 2026/06/29 19:43:28 adam Exp $
 lib/postgresql/timescaledb-${PKGVERSION}.${SHLIB_EXT}
 ${PLIST.tsl}lib/postgresql/timescaledb-tsl-${PKGVERSION}.${SHLIB_EXT}
 lib/postgresql/timescaledb.${SHLIB_EXT}
@@ -58,6 +58,8 @@ share/postgresql/extension/timescaledb--
 share/postgresql/extension/timescaledb--2.26.4--${PKGVERSION}.sql
 share/postgresql/extension/timescaledb--2.27.0--${PKGVERSION}.sql
 share/postgresql/extension/timescaledb--2.27.1--${PKGVERSION}.sql
+share/postgresql/extension/timescaledb--2.27.2--${PKGVERSION}.sql
+share/postgresql/extension/timescaledb--2.28.0--${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.51 pkgsrc/databases/postgresql-timescaledb/distinfo:1.52
--- pkgsrc/databases/postgresql-timescaledb/distinfo:1.51       Wed Jun  3 07:11:30 2026
+++ pkgsrc/databases/postgresql-timescaledb/distinfo    Mon Jun 29 19:43:28 2026
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.51 2026/06/03 07:11:30 adam Exp $
+$NetBSD: distinfo,v 1.52 2026/06/29 19:43:28 adam Exp $
 
-BLAKE2s (timescaledb-2.27.2.tar.gz) = b8f2f719de874dc64ec7a097710d08bc4378a6837cb02a032b23615c581f5a21
-SHA512 (timescaledb-2.27.2.tar.gz) = 1eda64bbe2aabd4d29c5ef140e3b80bf63e4d9bdcd174814c9674ffc5a79d2307cfdd7d6d1438941519779e291265e2b0ba9618ae0436794021d404eaecfca4e
-Size (timescaledb-2.27.2.tar.gz) = 8672918 bytes
+BLAKE2s (timescaledb-2.28.1.tar.gz) = 33bcffd44affae678177640141b24168530d9e370e5fe5852c77f57064b07b3e
+SHA512 (timescaledb-2.28.1.tar.gz) = d8eb22b4ce3cc9b9818e808170bcb0fb0e8a639ff19cf79204668373e63ad85d4697156e96ae172f3f173dc77082c1a22261b8ab4adae12ec7affc4c941e6d4c
+Size (timescaledb-2.28.1.tar.gz) = 8883635 bytes