CVS commit: pkgsrc/databases/postgresql-timescaledb

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

Module Name:    pkgsrc
Committed By:   adam
Date:           Sun Aug  4 07:26:04 UTC 2024

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

Log Message:
postgresql-timescaledb: updated to 2.16.0

2.16.0

This release contains significant performance improvements when working with compressed data, extended join
support in continuous aggregates, and the ability to define foreign keys from regular tables towards hypertables.
We recommend that you upgrade at the next available opportunity.

In TimescaleDB v2.16.0 we:

Introduce multiple performance focused optimizations for data manipulation operations (DML) over compressed chunks.
Improved upsert performance by more than 100x in some cases and more than 1000x in some update/delete scenarios.
Add the ability to define chunk skipping indexes on non-partitioning columns of compressed hypertables
TimescaleDB v2.16.0 extends chunk exclusion to use those skipping (sparse) indexes when queries filter on the relevant columns,
and prune chunks that do not include any relevant data for calculating the query response.
Offer new options for use cases that require foreign keys defined.
You can now add foreign keys from regular tables towards hypertables. We have also removed
some really annoying locks in the reverse direction that blocked access to referenced tables
while compression was running.
Extend Continuous Aggregates to support more types of analytical queries.
More types of joins are supported, additional equality operators on join clauses, and
support for joins between multiple regular tables.
Highlighted features in this release

Improved query performance through chunk exclusion on compressed hypertables.
You can now define chunk skipping indexes on compressed chunks for any column with one of the following
integer data types: smallint, int, bigint, serial, bigserial, date, timestamp, timestamptz.

After you call enable_chunk_skipping on a column, TimescaleDB tracks the min and max values for
that column. TimescaleDB uses that information to exclude chunks for queries that filter on that
column, and would not find any data in those chunks.

Improved upsert performance on compressed hypertables.
By using index scans to verify constraints during inserts on compressed chunks, TimescaleDB speeds
up some ON CONFLICT clauses by more than 100x.

Improved performance of updates, deletes, and inserts on compressed hypertables.
By filtering data while accessing the compressed data and before decompressing, TimescaleDB has
improved performance for updates and deletes on all types of compressed chunks, as well as inserts
into compressed chunks with unique constraints.

By signaling constraint violations without decompressing, or decompressing only when matching
records are found in the case of updates, deletes and upserts, TimescaleDB v2.16.0 speeds
up those operations more than 1000x in some update/delete scenarios, and 10x for upserts.

You can add foreign keys from regular tables to hypertables, with support for all types of cascading options.
This is useful for hypertables that partition using sequential IDs, and need to reference those IDs from other tables.

Lower locking requirements during compression for hypertables with foreign keys
Advanced foreign key handling removes the need for locking referenced tables when new chunks are compressed.
DML is no longer blocked on referenced tables while compression runs on a hypertable.

Improved support for queries on Continuous Aggregates
INNER/LEFT and LATERAL joins are now supported. Plus, you can now join with multiple regular tables,
and you can have more than one equality operator on join clauses.

PostgreSQL 13 support removal announcement

Following the deprecation announcement for PostgreSQL 13 in TimescaleDB v2.13,
PostgreSQL 13 is no longer supported in TimescaleDB v2.16.

The Currently supported PostgreSQL major versions are 14, 15 and 16.


To generate a diff of this commit:
cvs rdiff -u -r1.31 -r1.32 pkgsrc/databases/postgresql-timescaledb/Makefile
cvs rdiff -u -r1.28 -r1.29 pkgsrc/databases/postgresql-timescaledb/PLIST
cvs rdiff -u -r1.30 -r1.31 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.31 pkgsrc/databases/postgresql-timescaledb/Makefile:1.32
--- pkgsrc/databases/postgresql-timescaledb/Makefile:1.31       Sat Jul 13 05:22:59 2024
+++ pkgsrc/databases/postgresql-timescaledb/Makefile    Sun Aug  4 07:26:04 2024
@@ -1,6 +1,6 @@
-# $NetBSD: Makefile,v 1.31 2024/07/13 05:22:59 adam Exp $
+# $NetBSD: Makefile,v 1.32 2024/08/04 07:26:04 adam Exp $
 
-DISTNAME=      timescaledb-2.15.3
+DISTNAME=      timescaledb-2.16.0
 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 13
+PGSQL_VERSIONS_ACCEPTED=       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.28 pkgsrc/databases/postgresql-timescaledb/PLIST:1.29
--- pkgsrc/databases/postgresql-timescaledb/PLIST:1.28  Sat Jul 13 05:22:59 2024
+++ pkgsrc/databases/postgresql-timescaledb/PLIST       Sun Aug  4 07:26:04 2024
@@ -1,10 +1,8 @@
-@comment $NetBSD: PLIST,v 1.28 2024/07/13 05:22:59 adam Exp $
+@comment $NetBSD: PLIST,v 1.29 2024/08/04 07:26:04 adam Exp $
 lib/postgresql/timescaledb-${PKGVERSION}.${SOEXT}
 ${PLIST.tsl}lib/postgresql/timescaledb-tsl-${PKGVERSION}.${SOEXT}
 lib/postgresql/timescaledb.${SOEXT}
 share/postgresql/extension/timescaledb--${PKGVERSION}.sql
-share/postgresql/extension/timescaledb--2.1.0--${PKGVERSION}.sql
-share/postgresql/extension/timescaledb--2.1.1--${PKGVERSION}.sql
 share/postgresql/extension/timescaledb--2.10.0--${PKGVERSION}.sql
 share/postgresql/extension/timescaledb--2.10.1--${PKGVERSION}.sql
 share/postgresql/extension/timescaledb--2.10.2--${PKGVERSION}.sql
@@ -23,13 +21,7 @@ share/postgresql/extension/timescaledb--
 share/postgresql/extension/timescaledb--2.15.0--${PKGVERSION}.sql
 share/postgresql/extension/timescaledb--2.15.1--${PKGVERSION}.sql
 share/postgresql/extension/timescaledb--2.15.2--${PKGVERSION}.sql
-share/postgresql/extension/timescaledb--2.2.0--${PKGVERSION}.sql
-share/postgresql/extension/timescaledb--2.2.1--${PKGVERSION}.sql
-share/postgresql/extension/timescaledb--2.3.0--${PKGVERSION}.sql
-share/postgresql/extension/timescaledb--2.3.1--${PKGVERSION}.sql
-share/postgresql/extension/timescaledb--2.4.0--${PKGVERSION}.sql
-share/postgresql/extension/timescaledb--2.4.1--${PKGVERSION}.sql
-share/postgresql/extension/timescaledb--2.4.2--${PKGVERSION}.sql
+share/postgresql/extension/timescaledb--2.15.3--${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.30 pkgsrc/databases/postgresql-timescaledb/distinfo:1.31
--- pkgsrc/databases/postgresql-timescaledb/distinfo:1.30       Sat Jul 13 05:22:59 2024
+++ pkgsrc/databases/postgresql-timescaledb/distinfo    Sun Aug  4 07:26:04 2024
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.30 2024/07/13 05:22:59 adam Exp $
+$NetBSD: distinfo,v 1.31 2024/08/04 07:26:04 adam Exp $
 
-BLAKE2s (timescaledb-2.15.3.tar.gz) = 96f5cb6c22d782a9c553c32d1912db55029ecec245ecc385f481387f3ffe6774
-SHA512 (timescaledb-2.15.3.tar.gz) = c259bea088a03286a392812b23eda05ba7e5c714f9b52cd25b39ea9a280c5147e43d13a71027c43a5029df03e021a0022feb1ae311baae577ec3c56f1d7dfcae
-Size (timescaledb-2.15.3.tar.gz) = 7441097 bytes
+BLAKE2s (timescaledb-2.16.0.tar.gz) = a79505730e53609dfa36db2d8fdf6e1f2fde05f639b06bb27ece8c4e6c3fc477
+SHA512 (timescaledb-2.16.0.tar.gz) = 1476f0d3cbc5881911d5126799e28a5fda9c2e762ab8d0470e4c6d7dc715b099b2899b1f5dcb6d31c6cebf97a82007c1d18340e83fff8c9f72523574eb690732
+Size (timescaledb-2.16.0.tar.gz) = 7449437 bytes