Received: from localhost (localhost [127.0.0.1]) by mail.netbsd.org (Postfix) with ESMTP id 523B984CC8 for ; Wed, 2 Aug 2023 06:38:31 +0000 (UTC) X-Virus-Scanned: amavisd-new at netbsd.org Received: from mail.netbsd.org ([127.0.0.1]) by localhost (mail.netbsd.org [127.0.0.1]) (amavisd-new, port 10025) with ESMTP id LpLind8DC810 for ; Wed, 2 Aug 2023 06:38:30 +0000 (UTC) Received: from cvs.NetBSD.org (ivanova.netbsd.org [199.233.217.197]) by mail.netbsd.org (Postfix) with ESMTP id 6B10184CD0 for ; Wed, 2 Aug 2023 06:38:30 +0000 (UTC) Received: by cvs.NetBSD.org (Postfix, from userid 500) id 604C4FBDB; Wed, 2 Aug 2023 06:38:30 +0000 (UTC) Content-Transfer-Encoding: 7bit Content-Type: multipart/mixed; boundary="_----------=_169095831088240" MIME-Version: 1.0 Date: Wed, 2 Aug 2023 06:38:30 +0000 From: "Adam Ciarcinski" Subject: CVS commit: pkgsrc/databases/postgresql-timescaledb To: pkgsrc-changes@NetBSD.org Approved: commit_and_comment Reply-To: adam@netbsd.org X-Mailer: log_accum Message-Id: <20230802063830.604C4FBDB@cvs.NetBSD.org> This is a multi-part message in MIME format. --_----------=_169095831088240 Content-Disposition: inline Content-Transfer-Encoding: 8bit Content-Type: text/plain; charset="US-ASCII" Module Name: pkgsrc Committed By: adam Date: Wed Aug 2 06:38:30 UTC 2023 Modified Files: pkgsrc/databases/postgresql-timescaledb: Makefile PLIST distinfo Log Message: postgresql-timescaledb: updated to 2.11.1 2.11.1 (2023-06-29) This release contains bug fixes since the 2.11.0 release. We recommend that you upgrade at the next available opportunity. **Features** * Update the loader to add support for the OSM extension (used for data tiering on [Timescale](https://www.timescale.com/)) **Bugfixes** * Scheduler accidentally getting killed when calling `delete_job` * Fix Result node handling with ConstraintAwareAppend on compressed chunks * Ensure tlist is present in decompress chunk plan * Fixed handling of NULL values in bookend_sfunc * Fixed batch look ahead in compressed sorted merge * Mark cagg_watermark function as PARALLEL RESTRICTED * Copy job config JSONB structure into current MemoryContext * Improve continuous aggregate query chunk exclusion 2.11.0 (2023-05-12) This release contains new features and bug fixes since the 2.10.3 release. We deem it moderate priority for upgrading. This release includes these noteworthy features: * Support for DML operations on compressed chunks: * UPDATE/DELETE support * Support for unique constraints on compressed chunks * Support for `ON CONFLICT DO UPDATE` * Support for `ON CONFLICT DO NOTHING` * Join support for Hierarchical Continuous Aggregates * Performance improvements for real-time Hierarchical Continuous Aggregates **Features** * Allow pushdown of reference table joins * Improve Realtime Continuous Aggregate performance * Improve unique constraint support on compressed hypertables * Support UPDATE/DELETE on compressed hypertables * Enable JOINS for Hierarchical Continuous Aggregates * Add parallel support for partialize_agg() * Refactor and optimize distributed COPY * Add support for ON CONFLICT DO UPDATE for compressed hypertables * Skip Ordered Append when only 1 child node is present * Propagate vacuum/analyze to compressed chunks * Reduce decompression during constraint checking * Optimize compressed chunk resorting * Support sending telemetry event reports **Bugfixes** * Fix SEGMENTBY columns predicates to be pushed down * Handle user-defined FDW options properly * Decompression may have lost DEFAULT values * Fix issue creating dimensional constraints * Improve interpolate error message on datatype mismatch * Fix unique constraint on compressed tables * Add permission checks to run_job() * Enable run_job() for telemetry job * Fix on-insert decompression after schema changes * Quote username identifier appropriately * Fix tablespace for compressed hypertable and corresponding toast * Fix ALTER TABLE SET with normal tables * Reduce memory usage for distributed analyze * Fix subtransaction resource owner To generate a diff of this commit: cvs rdiff -u -r1.20 -r1.21 pkgsrc/databases/postgresql-timescaledb/Makefile cvs rdiff -u -r1.17 -r1.18 pkgsrc/databases/postgresql-timescaledb/PLIST cvs rdiff -u -r1.19 -r1.20 pkgsrc/databases/postgresql-timescaledb/distinfo Please note that diffs are not public domain; they are subject to the copyright notices on the relevant files. --_----------=_169095831088240 Content-Disposition: inline Content-Length: 3378 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.20 pkgsrc/databases/postgresql-timescaledb/Makefile:1.21 --- pkgsrc/databases/postgresql-timescaledb/Makefile:1.20 Fri Apr 28 07:34:42 2023 +++ pkgsrc/databases/postgresql-timescaledb/Makefile Wed Aug 2 06:38:30 2023 @@ -1,6 +1,6 @@ -# $NetBSD: Makefile,v 1.20 2023/04/28 07:34:42 adam Exp $ +# $NetBSD: Makefile,v 1.21 2023/08/02 06:38:30 adam Exp $ -DISTNAME= timescaledb-2.10.3 +DISTNAME= timescaledb-2.11.1 PKGNAME= postgresql${PGSQL_VERSION}-${DISTNAME} CATEGORIES= databases MASTER_SITES= ${MASTER_SITE_GITHUB:=timescale/} @@ -13,7 +13,6 @@ LICENSE= apache-2.0 DEPENDS+= postgresql${PGSQL_VERSION}-server>=0:../../databases/postgresql${PGSQL_VERSION}-server -USE_CMAKE= yes CMAKE_ARGS+= -DUSE_OPENSSL=ON CMAKE_ARGS+= -DREGRESS_CHECKS=OFF @@ -39,5 +38,6 @@ PLIST.tsl= yes CMAKE_ARGS+= -DAPACHE_ONLY=ON .endif +.include "../../devel/cmake/build.mk" .include "../../mk/pgsql.buildlink3.mk" .include "../../mk/bsd.pkg.mk" Index: pkgsrc/databases/postgresql-timescaledb/PLIST diff -u pkgsrc/databases/postgresql-timescaledb/PLIST:1.17 pkgsrc/databases/postgresql-timescaledb/PLIST:1.18 --- pkgsrc/databases/postgresql-timescaledb/PLIST:1.17 Fri Apr 28 07:34:42 2023 +++ pkgsrc/databases/postgresql-timescaledb/PLIST Wed Aug 2 06:38:30 2023 @@ -1,4 +1,4 @@ -@comment $NetBSD: PLIST,v 1.17 2023/04/28 07:34:42 adam Exp $ +@comment $NetBSD: PLIST,v 1.18 2023/08/02 06:38:30 adam Exp $ lib/postgresql/timescaledb-${PKGVERSION}.so ${PLIST.tsl}lib/postgresql/timescaledb-tsl-${PKGVERSION}.so lib/postgresql/timescaledb.so @@ -21,6 +21,8 @@ share/postgresql/extension/timescaledb-- 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 +share/postgresql/extension/timescaledb--2.10.3--${PKGVERSION}.sql +share/postgresql/extension/timescaledb--2.11.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.19 pkgsrc/databases/postgresql-timescaledb/distinfo:1.20 --- pkgsrc/databases/postgresql-timescaledb/distinfo:1.19 Fri Apr 28 07:34:42 2023 +++ pkgsrc/databases/postgresql-timescaledb/distinfo Wed Aug 2 06:38:30 2023 @@ -1,5 +1,5 @@ -$NetBSD: distinfo,v 1.19 2023/04/28 07:34:42 adam Exp $ +$NetBSD: distinfo,v 1.20 2023/08/02 06:38:30 adam Exp $ -BLAKE2s (timescaledb-2.10.3.tar.gz) = a027a042f14afc3da02a4ff87baaaee3b82f3677ed30ecb343cab6a6ff2a16e5 -SHA512 (timescaledb-2.10.3.tar.gz) = c94227d9aa1df36634bbf2626f580165860cab543efbfeb448f9799cf70ef6c1891af0077c2280ae22dbfb2360cf2b6012e7f05c26b0cf7aef6eb217c583b444 -Size (timescaledb-2.10.3.tar.gz) = 7465897 bytes +BLAKE2s (timescaledb-2.11.1.tar.gz) = 745bd5dbb6908e7f91dfef195a203eb9799b6810fecba27fe781e72b52e7a64c +SHA512 (timescaledb-2.11.1.tar.gz) = e29a378bfe1e5bb72d6d9bd430b972d1e14cf2345f2599559f73075146fd8c5839f08459880681140eff607b152671beeb1876bf509008ad2b653d258eb356b8 +Size (timescaledb-2.11.1.tar.gz) = 7723360 bytes --_----------=_169095831088240--