CVS commit: pkgsrc/databases/postgresql-timescaledb

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

Module Name:    pkgsrc
Committed By:   adam
Date:           Fri Nov  8 13:46:49 UTC 2024

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

Log Message:
postgresql-timescaledb: updated to 2.17.2

2.17.2 (2024-11-06)

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

Bugfixes

Fix "negative bitmapset member not allowed" and performance degradation
on queries to compressed tables with ORDER BY clause matching the order of the
compressed data
Use-after-free in vectorized grouping by segmentby columns

2.17.1 (2024-10-21)

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

Features

Add chunk skipping GUC
Bugfixes

Change log level used in compression
Fix collation for in-memory tuple filtering

2.17.0 (2024-10-08)

This release adds support for PostgreSQL 17, significantly improves the performance of continuous aggregate refreshes, and contains performance improvements for analytical queries and delete 
operations over compressed hypertables.
We recommend that you upgrade at the next available opportunity.

Highlighted features in TimescaleDB v2.17.0

Full PostgreSQL 17 support for all existing features. TimescaleDB v2.17 is available for PostgreSQL 14, 15, 16, and 17.

Significant performance improvements for continuous aggregate policies:
Continuous aggregate refresh is now using merge instead of deleting old materialized data and re-inserting. This update can decrease dramatically the amount of data that must be written on the 
continuous aggregate in the presence of a small number of changes, reduce the i/o cost of refreshing a continuous aggregate, and generate fewer Write-Ahead Logs (WAL). Overall, continuous aggregate 
policies will be more lightweight, use less system resources, and complete faster.

Increased performance for real-time analytical queries over compressed hypertables:
We are excited to introduce additional Single Instruction, Multiple Data (SIMD) vectorization optimization to our engine by supporting vectorized execution for queries that group by using the 
segment_by column(s) and aggregate using the basic aggregate functions (sum, count, avg, min, max).
Stay tuned for more to come in follow-up releases! Support for grouping
on additional columns, filtered aggregation,
vectorized expressions, and time_bucket is coming soon.

Improved performance of deletes on compressed hypertables when a large amount of data is affected.
This improvement speeds up operations that delete whole segments by skipping the decompression step. It is enabled for all deletes that filter by the segment_by column(s).


To generate a diff of this commit:
cvs rdiff -u -r1.34 -r1.35 pkgsrc/databases/postgresql-timescaledb/Makefile
cvs rdiff -u -r1.30 -r1.31 pkgsrc/databases/postgresql-timescaledb/PLIST
cvs rdiff -u -r1.32 -r1.33 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.34 pkgsrc/databases/postgresql-timescaledb/Makefile:1.35
--- pkgsrc/databases/postgresql-timescaledb/Makefile:1.34       Sun Aug 25 06:18:31 2024
+++ pkgsrc/databases/postgresql-timescaledb/Makefile    Fri Nov  8 13:46:49 2024
@@ -1,6 +1,6 @@
-# $NetBSD: Makefile,v 1.34 2024/08/25 06:18:31 wiz Exp $
+# $NetBSD: Makefile,v 1.35 2024/11/08 13:46:49 adam Exp $
 
-DISTNAME=      timescaledb-2.16.1
+DISTNAME=      timescaledb-2.17.2
 PKGNAME=       postgresql${PGSQL_VERSION}-${DISTNAME}
 CATEGORIES=    databases
 MASTER_SITES=  ${MASTER_SITE_GITHUB:=timescale/}
@@ -24,7 +24,7 @@ PLIST_SUBST+= SOEXT=dylib
 PLIST_SUBST+=  SOEXT=so
 .endif
 
-PGSQL_VERSIONS_ACCEPTED=       16 15 14
+PGSQL_VERSIONS_ACCEPTED=       17 16 15 14
 
 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.30 pkgsrc/databases/postgresql-timescaledb/PLIST:1.31
--- pkgsrc/databases/postgresql-timescaledb/PLIST:1.30  Wed Aug  7 09:40:31 2024
+++ pkgsrc/databases/postgresql-timescaledb/PLIST       Fri Nov  8 13:46:49 2024
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.30 2024/08/07 09:40:31 adam Exp $
+@comment $NetBSD: PLIST,v 1.31 2024/11/08 13:46:49 adam Exp $
 lib/postgresql/timescaledb-${PKGVERSION}.${SOEXT}
 ${PLIST.tsl}lib/postgresql/timescaledb-tsl-${PKGVERSION}.${SOEXT}
 lib/postgresql/timescaledb.${SOEXT}
@@ -23,6 +23,9 @@ share/postgresql/extension/timescaledb--
 share/postgresql/extension/timescaledb--2.15.2--${PKGVERSION}.sql
 share/postgresql/extension/timescaledb--2.15.3--${PKGVERSION}.sql
 share/postgresql/extension/timescaledb--2.16.0--${PKGVERSION}.sql
+share/postgresql/extension/timescaledb--2.16.1--${PKGVERSION}.sql
+share/postgresql/extension/timescaledb--2.17.0--${PKGVERSION}.sql
+share/postgresql/extension/timescaledb--2.17.1--${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

Index: pkgsrc/databases/postgresql-timescaledb/distinfo
diff -u pkgsrc/databases/postgresql-timescaledb/distinfo:1.32 pkgsrc/databases/postgresql-timescaledb/distinfo:1.33
--- pkgsrc/databases/postgresql-timescaledb/distinfo:1.32       Wed Aug  7 09:40:31 2024
+++ pkgsrc/databases/postgresql-timescaledb/distinfo    Fri Nov  8 13:46:49 2024
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.32 2024/08/07 09:40:31 adam Exp $
+$NetBSD: distinfo,v 1.33 2024/11/08 13:46:49 adam Exp $
 
-BLAKE2s (timescaledb-2.16.1.tar.gz) = 14cc25b9f2492a3b4950975669f1173afb9c15aa37a440faf20d90f6ba301716
-SHA512 (timescaledb-2.16.1.tar.gz) = 4972ccc385a3c7bda8fab8736c63f75c5b290a3a0206add84718326fcd07c24a52dbbae2114e857fb78246bf5a4b5ec3310cc2219a163af4d5f30f1766e37fae
-Size (timescaledb-2.16.1.tar.gz) = 7449327 bytes
+BLAKE2s (timescaledb-2.17.2.tar.gz) = c949b8c5889f6c286ce090241f9856ffb7f71a54a43b6e5db0832dd5b57901a4
+SHA512 (timescaledb-2.17.2.tar.gz) = fc74d41062735bd4136ac71b0e10aecf34a64cdb29fd2ff31eae3f406beb8db00866e8ed7e142d47852e1586a6ad2ffa1652fbd792a45e995174b62464963d1e
+Size (timescaledb-2.17.2.tar.gz) = 7567447 bytes