Received: by mail.netbsd.org (Postfix, from userid 605) id D2DF884D96; Mon, 22 Jan 2024 09:10:16 +0000 (UTC) Received: from localhost (localhost [127.0.0.1]) by mail.netbsd.org (Postfix) with ESMTP id 078E284D84 for ; Mon, 22 Jan 2024 09:10:16 +0000 (UTC) X-Virus-Scanned: amavisd-new at netbsd.org Received: from mail.netbsd.org ([IPv6:::1]) by localhost (mail.netbsd.org [IPv6:::1]) (amavisd-new, port 10025) with ESMTP id WZMEduYRHl1W for ; Mon, 22 Jan 2024 09:10:15 +0000 (UTC) Received: from cvs.NetBSD.org (ivanova.NetBSD.org [IPv6:2001:470:a085:999:28c:faff:fe03:5984]) by mail.netbsd.org (Postfix) with ESMTP id 0DC6D84CED for ; Mon, 22 Jan 2024 09:10:15 +0000 (UTC) Received: by cvs.NetBSD.org (Postfix, from userid 500) id 067ABFA42; Mon, 22 Jan 2024 09:10:15 +0000 (UTC) Content-Transfer-Encoding: 7bit Content-Type: multipart/mixed; boundary="_----------=_1705914614107750" MIME-Version: 1.0 Date: Mon, 22 Jan 2024 09:10:14 +0000 From: "Adam Ciarcinski" Subject: CVS commit: pkgsrc/databases/postgresql-timescaledb To: pkgsrc-changes@NetBSD.org Reply-To: adam@netbsd.org X-Mailer: log_accum Message-Id: <20240122091015.067ABFA42@cvs.NetBSD.org> Sender: pkgsrc-changes-owner@NetBSD.org List-Id: Precedence: bulk List-Unsubscribe: This is a multi-part message in MIME format. --_----------=_1705914614107750 Content-Disposition: inline Content-Transfer-Encoding: 8bit Content-Type: text/plain; charset="US-ASCII" Module Name: pkgsrc Committed By: adam Date: Mon Jan 22 09:10:14 UTC 2024 Modified Files: pkgsrc/databases/postgresql-timescaledb: Makefile PLIST distinfo Log Message: postgresql-timescaledb: updated to 2.13.1 2.13.1 (2024-01-09) This release contains bug fixes since the 2.13.0 release. We recommend that you upgrade at the next available opportunity. **Bugfixes** * Use numrows_pre_compression in approximate row count * Use processed group clauses in PG16 * Change bgw_log_level to use PGC_SUSET * Disable vectorized sum for expressions. * Read CAgg watermark from materialized data * Fix groupby pathkeys for gapfill in PG16 * Fix index matching during DML decompression * Fix compressed chunk permission handling on PG16 * Fix lost concurrent CAgg updates * Fix unique expression indexes on compressed chunks * Fix use of freed path in decompression sort logic **Thanks** * @MA-MacDonald for reporting an issue with gapfill in PG16 * @aarondglover for reporting an issue with unique expression indexes on compressed chunks * @adriangb for reporting an issue with security barrier views on pg16 2.13.0 (2023-11-28) This release contains performance improvements, an improved hypertable DDL API and bug fixes since the 2.12.2 release. We recommend that you upgrade at the next available opportunity. In addition, it includes these noteworthy features: * Full PostgreSQL 16 support for all existing features * Vectorized aggregation execution for sum() * Track chunk creation time used in retention/compression policies **Deprecation notice: Multi-node support** TimescaleDB 2.13 is the last version that will include multi-node support. Multi-node support in 2.13 is available for PostgreSQL 13, 14 and 15. Learn more about it [here](docs/MultiNodeDeprecation.md). If you want to migrate from multi-node TimescaleDB to single-node TimescaleDB read the [migration documentation](https://docs.timescale.com/migrate/latest/multi-node-to-timescale-service/). **PostgreSQL 13 deprecation announcement** We will continue supporting PostgreSQL 13 until April 2024. Sooner to that time, we will announce the specific version of TimescaleDB in which PostgreSQL 13 support will not be included going forward. **Starting from TimescaleDB 2.13.0** * No Amazon Machine Images (AMI) are published. If you previously used AMI, please use another [installation method](https://docs.timescale.com/self-hosted/latest/install/) * Continuous Aggregates are materialized only (non-realtime) by default **Features** * Add chunk-wise sorted paths for compressed chunks * Simplify hypertable DDL API * Reduce WAL activity by freezing compressed tuples immediately * Vectorized aggregation execution for sum() * Add metadata for chunk creation time * Make Continous Aggregates materialized only (non-realtime) by default * Change show_chunks/drop_chunks using chunk creation time * Show batches/tuples decompressed during DML operations in EXPLAIN output * Keep track of catalog version * Use creation time in retention/compression policy * Add SQL function cagg_validate_query **Bugfixes** * Add GUC for setting background worker log level * Allow enabling compression on hypertable with unique expression index * Check if worker registration succeeded * Fix exception detail passing in compression_policy_execute * Fix missing bms_del_member result assignment * Fix negative bitmapset member not allowed in compression * Potential data loss when compressing a table with a partial index that matches compression order. * Add support for startup chunk exclusion with aggs * Repair relacl on upgrade * Fix segfault when creating a cagg using a NULL width in time bucket function * Make timescaledb_functions.makeaclitem strict * Fix typmod and collation for segmentby columns * Fix tablespace with constraints * Enable segmentwise recompression in compression policy To generate a diff of this commit: cvs rdiff -u -r1.23 -r1.24 pkgsrc/databases/postgresql-timescaledb/Makefile cvs rdiff -u -r1.20 -r1.21 pkgsrc/databases/postgresql-timescaledb/PLIST cvs rdiff -u -r1.22 -r1.23 pkgsrc/databases/postgresql-timescaledb/distinfo Please note that diffs are not public domain; they are subject to the copyright notices on the relevant files. --_----------=_1705914614107750 Content-Disposition: inline Content-Length: 3803 Content-Transfer-Encoding: binary Content-Type: text/x-diff; charset=us-ascii Modified files: Index: pkgsrc/databases/postgresql-timescaledb/Makefile diff -u pkgsrc/databases/postgresql-timescaledb/Makefile:1.23 pkgsrc/databases/postgresql-timescaledb/Makefile:1.24 --- pkgsrc/databases/postgresql-timescaledb/Makefile:1.23 Fri Nov 3 09:15:34 2023 +++ pkgsrc/databases/postgresql-timescaledb/Makefile Mon Jan 22 09:10:14 2024 @@ -1,6 +1,6 @@ -# $NetBSD: Makefile,v 1.23 2023/11/03 09:15:34 adam Exp $ +# $NetBSD: Makefile,v 1.24 2024/01/22 09:10:14 adam Exp $ -DISTNAME= timescaledb-2.12.1 +DISTNAME= timescaledb-2.13.1 PKGNAME= postgresql${PGSQL_VERSION}-${DISTNAME} CATEGORIES= databases MASTER_SITES= ${MASTER_SITE_GITHUB:=timescale/} @@ -16,7 +16,15 @@ DEPENDS+= postgresql${PGSQL_VERSION}-ser CMAKE_ARGS+= -DUSE_OPENSSL=ON CMAKE_ARGS+= -DREGRESS_CHECKS=OFF -PGSQL_VERSIONS_ACCEPTED= 15 14 13 +.include "../../mk/bsd.prefs.mk" + +.if ${SHLIB_TYPE} == "dylib" +PLIST_SUBST+= SOEXT=dylib +.else +PLIST_SUBST+= SOEXT=so +.endif + +PGSQL_VERSIONS_ACCEPTED= 16 15 14 13 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.20 pkgsrc/databases/postgresql-timescaledb/PLIST:1.21 --- pkgsrc/databases/postgresql-timescaledb/PLIST:1.20 Fri Nov 3 09:15:34 2023 +++ pkgsrc/databases/postgresql-timescaledb/PLIST Mon Jan 22 09:10:14 2024 @@ -1,7 +1,7 @@ -@comment $NetBSD: PLIST,v 1.20 2023/11/03 09:15:34 adam Exp $ -lib/postgresql/timescaledb-${PKGVERSION}.so -${PLIST.tsl}lib/postgresql/timescaledb-tsl-${PKGVERSION}.so -lib/postgresql/timescaledb.so +@comment $NetBSD: PLIST,v 1.21 2024/01/22 09:10:14 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 @@ -13,6 +13,9 @@ share/postgresql/extension/timescaledb-- share/postgresql/extension/timescaledb--2.11.1--${PKGVERSION}.sql share/postgresql/extension/timescaledb--2.11.2--${PKGVERSION}.sql share/postgresql/extension/timescaledb--2.12.0--${PKGVERSION}.sql +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.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.22 pkgsrc/databases/postgresql-timescaledb/distinfo:1.23 --- pkgsrc/databases/postgresql-timescaledb/distinfo:1.22 Fri Nov 3 09:15:34 2023 +++ pkgsrc/databases/postgresql-timescaledb/distinfo Mon Jan 22 09:10:14 2024 @@ -1,5 +1,5 @@ -$NetBSD: distinfo,v 1.22 2023/11/03 09:15:34 adam Exp $ +$NetBSD: distinfo,v 1.23 2024/01/22 09:10:14 adam Exp $ -BLAKE2s (timescaledb-2.12.1.tar.gz) = d94a4e557f6da33f65b10d107bc1f3d085dff560da874a3e122a2617eda73e7d -SHA512 (timescaledb-2.12.1.tar.gz) = 0b005446eab4f3b3cf1abea6ef1cbbd77a50de40402bba1a9ba5049315b4c8ecba0e45af3288c865076534b3b0eaca68cdbe31026deaca1cdb2ab5f493bfb925 -Size (timescaledb-2.12.1.tar.gz) = 7519337 bytes +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 --_----------=_1705914614107750--