CVS commit: pkgsrc/databases/postgresql-timescaledb

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

Module Name:    pkgsrc
Committed By:   adam
Date:           Sat Feb 10 11:04:53 UTC 2024

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

Log Message:
postgresql-timescaledb: updated to 2.14.0

2.14.0

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

In addition, it includes these noteworthy features:

Ability to change compression settings on existing compressed hypertables at any time.
New compression settings take effect on any new chunks that are compressed after the change.
Reduced locking requirements during chunk recompression
Limiting tuple decompression during DML operations to avoid decompressing a lot of tuples and causing storage issues (100k limit, configurable)
Helper functions for determining compression settings
Plan-time chunk exclusion for real-time Continuous Aggregate by constify the cagg_watermark function call, leading to faster queries using real-time continuous aggregates
For this release only, you will need to restart the database before running ALTER EXTENSION

Multi-node support removal announcement
Following the deprecation announcement for Multi-node in TimescaleDB 2.13,
Multi-node is no longer supported starting with TimescaleDB 2.14.

TimescaleDB 2.13 is the last version that includes multi-node support. Learn more about it here.

If you want to migrate from multi-node TimescaleDB to single-node TimescaleDB, read the
migration documentation.

Deprecation notice: recompress_chunk procedure
TimescaleDB 2.14 is the last version that will include the recompress_chunk procedure. Its
functionality will be replaced by the compress_chunk function, which, starting on TimescaleDB 2.14,
works on both uncompressed and partially compressed chunks.
The compress_chunk function should be used going forward to fully compress all types of chunks or even recompress
old fully compressed chunks using new compression settings (through the newly introduced recompress optional parameter).

Features

* Add plan-time chunk exclusion for real-time CAggs
* Remove support for creating Continuous Aggregates with old format
* Add functions for determining compression defaults
* Remove multinode public API
* Allow SQLValueFunction pushdown into compressed scan
* Support approximate hypertable size
* Make compression settings per chunk
* Remove reindex_relation from recompression
* Fix if_not_exists behavior for CAgg policy with NULL offsets
* Remove restrictions for changing compression settings
* Limit tuple decompression during DML operations
* Change compress_chunk and decompress_chunk to idempotent version by default
* Add LWLock for OSM usage in loader
* Deprecate recompress_chunk
* Add optional recompress argument to compress_chunk

Bugfixes

* Inefficient join plans on compressed hypertables.
* Enable now() plantime constification with BETWEEN
* Fix create_hypertable referenced by fk succeeds
* Suboptimal query plans when using time_bucket with query parameters
* time_bucket_gapfill with timezones doesn't handle daylight savings
* Make extension state available through function
* Log extension state changes
* Disallow triggers on CAggs
* Reduce locking level on compressed chunk index during segmentwise recompression
* Fix if_not_exists behavior for CAgg policy with NULL offsets
* Fix pathtarget adjustment for MergeAppend paths in aggregation pushdown code
* Fix compressed chunk not found during upserts
* Fix recompression policy ignoring partially compressed chunks
* Ensure qsort comparison function is transitive


To generate a diff of this commit:
cvs rdiff -u -r1.24 -r1.25 pkgsrc/databases/postgresql-timescaledb/Makefile
cvs rdiff -u -r1.21 -r1.22 pkgsrc/databases/postgresql-timescaledb/PLIST
cvs rdiff -u -r1.23 -r1.24 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.24 pkgsrc/databases/postgresql-timescaledb/Makefile:1.25
--- pkgsrc/databases/postgresql-timescaledb/Makefile:1.24       Mon Jan 22 09:10:14 2024
+++ pkgsrc/databases/postgresql-timescaledb/Makefile    Sat Feb 10 11:04:53 2024
@@ -1,6 +1,6 @@
-# $NetBSD: Makefile,v 1.24 2024/01/22 09:10:14 adam Exp $
+# $NetBSD: Makefile,v 1.25 2024/02/10 11:04:53 adam Exp $
 
-DISTNAME=      timescaledb-2.13.1
+DISTNAME=      timescaledb-2.14.0
 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.21 pkgsrc/databases/postgresql-timescaledb/PLIST:1.22
--- pkgsrc/databases/postgresql-timescaledb/PLIST:1.21  Mon Jan 22 09:10:14 2024
+++ pkgsrc/databases/postgresql-timescaledb/PLIST       Sat Feb 10 11:04:53 2024
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.21 2024/01/22 09:10:14 adam Exp $
+@comment $NetBSD: PLIST,v 1.22 2024/02/10 11:04:53 adam Exp $
 lib/postgresql/timescaledb-${PKGVERSION}.${SOEXT}
 ${PLIST.tsl}lib/postgresql/timescaledb-tsl-${PKGVERSION}.${SOEXT}
 lib/postgresql/timescaledb.${SOEXT}
@@ -16,6 +16,7 @@ share/postgresql/extension/timescaledb--
 share/postgresql/extension/timescaledb--2.12.1--${PKGVERSION}.sql
 share/postgresql/extension/timescaledb--2.12.2--${PKGVERSION}.sql
 share/postgresql/extension/timescaledb--2.13.0--${PKGVERSION}.sql
+share/postgresql/extension/timescaledb--2.13.1--${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

Index: pkgsrc/databases/postgresql-timescaledb/distinfo
diff -u pkgsrc/databases/postgresql-timescaledb/distinfo:1.23 pkgsrc/databases/postgresql-timescaledb/distinfo:1.24
--- pkgsrc/databases/postgresql-timescaledb/distinfo:1.23       Mon Jan 22 09:10:14 2024
+++ pkgsrc/databases/postgresql-timescaledb/distinfo    Sat Feb 10 11:04:53 2024
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.23 2024/01/22 09:10:14 adam Exp $
+$NetBSD: distinfo,v 1.24 2024/02/10 11:04:53 adam Exp $
 
-BLAKE2s (timescaledb-2.13.1.tar.gz) = af0b4f798590feb2d89c93d5facfe41f4e553ae1fdd03c83b3558d186301b013
-SHA512 (timescaledb-2.13.1.tar.gz) = 4416d5a3693ebe20af95903abc4fbd54b13651acbb9a3b4a0eb5cbd69d00c54d73f2abcdfe195edd9f6d14a90667121dac5b3adea20b3efbe50e0318c340c8be
-Size (timescaledb-2.13.1.tar.gz) = 8239930 bytes
+BLAKE2s (timescaledb-2.14.0.tar.gz) = a56fe80ce03f731995283261acdaa77b322f3458cb1e2559d0f362515b417cfe
+SHA512 (timescaledb-2.14.0.tar.gz) = 75a66a51de313fa1beb4a576181888dbe742ffa0325b5813b5b12749c9fc97705eaa030186e424a360ee20745226768a679632182c079117586c5e4a5c108236
+Size (timescaledb-2.14.0.tar.gz) = 7316149 bytes