CVS commit: pkgsrc/databases/postgresql-timescaledb

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

Module Name:    pkgsrc
Committed By:   adam
Date:           Mon May 19 09:11:27 UTC 2025

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

Log Message:
postgresql-timescaledb: updated to 2.20.0

2.20.0

Highlighted features in TimescaleDB v2.20.0

The columnstore now leverages bloom filters to deliver up to 6x faster point queries on columns with high cardinality values, such as UUIDs.
Major improvements to the columnstores' backfill process enable UPSERTS with strict constraints to execute up to 10x faster.
SkipScan is now supported in the columnstore, including for DISTINCT queries. This enhancement leads to dramatic query performance improvements of 2000x to 2500x, especially for selective queries.
SIMD vectorization for the bool data type is now enabled by default. This change results in a 30–45% increase in performance for analytical queries with bool clauses on the columnstore.
Continuous aggregates now include experimental support for window functions and non-immutable functions, extending the analytics use cases they can solve.
Several quality-of-life improvements have been introduced: job names for continuous aggregates are now more descriptive, you can assign custom names to them, and it is now possible to add unique 
constraints along with ADD COLUMN operations in the columnstore.
Improved management and optimization of chunks with the ability to split large uncompressed chunks at a specified point in time using the split_chunk function. This new function complements the 
existing merge_chunk function that can be used to merge two small chunks into one larger chunk.
Enhancements to the default behavior of the columnstore now provide better automatic assessments of segment by and order by columns, reducing the need for manual configuration and simplifying initial 
setup.

PostgreSQL 14 support removal announcement

Following the deprecation announcement for PostgreSQL 14 in TimescaleDB v2.19.0, PostgreSQL 14 is no longer supported in TimescaleDB v2.20.0. The currently supported PostgreSQL major versions are 15, 
16, and 17.


To generate a diff of this commit:
cvs rdiff -u -r1.41 -r1.42 pkgsrc/databases/postgresql-timescaledb/Makefile
cvs rdiff -u -r1.37 -r1.38 pkgsrc/databases/postgresql-timescaledb/PLIST
cvs rdiff -u -r1.38 -r1.39 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.41 pkgsrc/databases/postgresql-timescaledb/Makefile:1.42
--- pkgsrc/databases/postgresql-timescaledb/Makefile:1.41       Tue May  6 09:44:07 2025
+++ pkgsrc/databases/postgresql-timescaledb/Makefile    Mon May 19 09:11:27 2025
@@ -1,6 +1,6 @@
-# $NetBSD: Makefile,v 1.41 2025/05/06 09:44:07 wiz Exp $
+# $NetBSD: Makefile,v 1.42 2025/05/19 09:11:27 adam Exp $
 
-DISTNAME=      timescaledb-2.19.3
+DISTNAME=      timescaledb-2.20.0
 PKGNAME=       postgresql${PGSQL_VERSION}-${DISTNAME}
 CATEGORIES=    databases
 MASTER_SITES=  ${MASTER_SITE_GITHUB:=timescale/}
@@ -16,7 +16,7 @@ DEPENDS+=     postgresql${PGSQL_VERSION}-ser
 CMAKE_CONFIGURE_ARGS+= -DUSE_OPENSSL=ON
 CMAKE_CONFIGURE_ARGS+= -DREGRESS_CHECKS=OFF
 
-PGSQL_VERSIONS_ACCEPTED=       17 16 15 14
+PGSQL_VERSIONS_ACCEPTED=       17 16 15
 
 PKG_OPTIONS_VAR=               PKG_OPTIONS.timescaledb
 PKG_SUPPORTED_OPTIONS+=                timescale-license

Index: pkgsrc/databases/postgresql-timescaledb/PLIST
diff -u pkgsrc/databases/postgresql-timescaledb/PLIST:1.37 pkgsrc/databases/postgresql-timescaledb/PLIST:1.38
--- pkgsrc/databases/postgresql-timescaledb/PLIST:1.37  Tue May  6 09:44:07 2025
+++ pkgsrc/databases/postgresql-timescaledb/PLIST       Mon May 19 09:11:27 2025
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.37 2025/05/06 09:44:07 wiz Exp $
+@comment $NetBSD: PLIST,v 1.38 2025/05/19 09:11:27 adam Exp $
 lib/postgresql/timescaledb-${PKGVERSION}.${SHLIB_EXT}
 ${PLIST.tsl}lib/postgresql/timescaledb-tsl-${PKGVERSION}.${SHLIB_EXT}
 lib/postgresql/timescaledb.${SHLIB_EXT}
@@ -33,16 +33,7 @@ share/postgresql/extension/timescaledb--
 share/postgresql/extension/timescaledb--2.19.0--${PKGVERSION}.sql
 share/postgresql/extension/timescaledb--2.19.1--${PKGVERSION}.sql
 share/postgresql/extension/timescaledb--2.19.2--${PKGVERSION}.sql
-share/postgresql/extension/timescaledb--2.5.0--${PKGVERSION}.sql
-share/postgresql/extension/timescaledb--2.5.1--${PKGVERSION}.sql
-share/postgresql/extension/timescaledb--2.5.2--${PKGVERSION}.sql
-share/postgresql/extension/timescaledb--2.6.0--${PKGVERSION}.sql
-share/postgresql/extension/timescaledb--2.6.1--${PKGVERSION}.sql
-share/postgresql/extension/timescaledb--2.7.0--${PKGVERSION}.sql
-share/postgresql/extension/timescaledb--2.7.1--${PKGVERSION}.sql
-share/postgresql/extension/timescaledb--2.7.2--${PKGVERSION}.sql
-share/postgresql/extension/timescaledb--2.8.0--${PKGVERSION}.sql
-share/postgresql/extension/timescaledb--2.8.1--${PKGVERSION}.sql
+share/postgresql/extension/timescaledb--2.19.3--${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.38 pkgsrc/databases/postgresql-timescaledb/distinfo:1.39
--- pkgsrc/databases/postgresql-timescaledb/distinfo:1.38       Thu Apr 17 04:59:38 2025
+++ pkgsrc/databases/postgresql-timescaledb/distinfo    Mon May 19 09:11:27 2025
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.38 2025/04/17 04:59:38 adam Exp $
+$NetBSD: distinfo,v 1.39 2025/05/19 09:11:27 adam Exp $
 
-BLAKE2s (timescaledb-2.19.3.tar.gz) = e645a97b3de895540d2125c31031346dab3372e8c9face9f7be09b460fce574e
-SHA512 (timescaledb-2.19.3.tar.gz) = 44310ddced2899b6a60989fc5e96aa4c999898e5ec59a29ea1bc4c82e6ae9339fa11fd6e20805a2d09a351c1c6fe1429593367f73a91229043c02ba6648468e7
-Size (timescaledb-2.19.3.tar.gz) = 8010948 bytes
+BLAKE2s (timescaledb-2.20.0.tar.gz) = d92ebbb1c15929593c5ed339e1c09e6a35881bfa917be79a4a3f86e328f4238c
+SHA512 (timescaledb-2.20.0.tar.gz) = 78f80b78a6730da62f1dc6b86c35bda8edb91bb41d65ade0edd7e705e6ae54cb665509d6cb3fd464d060390892ca31cfd63a2f91a91b0a55490901ab5a5853cb
+Size (timescaledb-2.20.0.tar.gz) = 7784597 bytes