Fri Nov 3 09:15:34 2023 UTC ()
postgresql-timescaledb: updated to 2.12.2

2.12.2

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

Bugfixes

* Align gapfill bucket generation with time_bucket
* Ensure fixed_schedule field is populated
* Fix EXPLAIN ANALYZE for compressed DML

2.12.1

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

Bugfixes

* Fix planner distributed table count
* Avoid decompressing batches using an empty slot
* Fix concurrency errors in OSM API
* do not throw an error when deprecation GUC cannot be read

2.12.0

This release contains performance improvements for compressed hypertables
and continuous aggregates and bug fixes since the 2.11.2 release.
We recommend that you upgrade at the next available opportunity.

This release moves all internal functions from the _timescaleb_internal
schema into the _timescaledb_functions schema. This separates code from
internal data objects and improves security by allowing more restrictive
permissions for the code schema. If you are calling any of those internal
functions you should adjust your code as soon as possible. This version
also includes a compatibility layer that allows calling them in the old
location but that layer will be removed in 2.14.0.

PostgreSQL 12 support removal announcement
Following the deprecation announcement for PostgreSQL 12 in TimescaleDB 2.10,
PostgreSQL 12 is not supported starting with TimescaleDB 2.12.
Currently supported PostgreSQL major versions are 13, 14 and 15.
PostgreSQL 16 support will be added with a following TimescaleDB release.

Features

* Insert into index during chunk compression
* MERGE support on hypertables
* Make hypertables support replica identity
* Index scan support during UPDATE/DELETE on compressed hypertables
* Support for partial aggregations at chunk level
* Enable ChunkAppend for partially compressed chunks
* Improve the number of parallel workers for decompression
* Enable altering job schedule type through alter_job
* Make logrepl markers for (partial) decompressions
* Relax invalidation threshold table-level lock to row-level when refreshing a Continuous Aggregate
* Support CAgg names in chunk_detailed_size
* Make set_chunk_time_interval CAggs aware
* Allow ALTER TABLE ... REPLICA IDENTITY (FULL|INDEX) on materialized hypertables (continuous aggregates)
* Add job exit status and runtime to log
* CREATE INDEX ONLY ON hypertable creates index on chunks

Bugfixes

* Fix interval calculation for hierarchical CAggs
* Check unique indexes when enabling compression
* _timescaledb_internal.create_compressed_chunk doesn't account for existing uncompressed rows
* Move functions to _timescaledb_functions schema
* Chunk_create must add an existing table or fail
* Fix duplicates on partially compressed chunk reads
* Fix crash in COPY from program returning error
* Place data in first/last function in correct mctx
* Call eq_func correctly in time_bucket_gapfill
* Correct row count in EXPLAIN ANALYZE INSERT .. ON CONFLICT output
* Fix server crash on UPDATE of compressed chunk
* Fix server crash when using duplicate segmentby column
* Fix segfault in set_integer_now_func
* Fix approximate_row_count for CAggs
* Improve compressed DML datatype handling
* Propagate parameter changes to decompress child nodes
* Schedule compression policy more often


(adam)
diff -r1.22 -r1.23 pkgsrc/databases/postgresql-timescaledb/Makefile
diff -r1.19 -r1.20 pkgsrc/databases/postgresql-timescaledb/PLIST
diff -r1.21 -r1.22 pkgsrc/databases/postgresql-timescaledb/distinfo
cvs diff -r1.22 -r1.23 pkgsrc/databases/postgresql-timescaledb/Makefile (expand / switch to unified diff)

--- pkgsrc/databases/postgresql-timescaledb/Makefile 2023/08/23 15:40:13 1.22
+++ pkgsrc/databases/postgresql-timescaledb/Makefile 2023/11/03 09:15:34 1.23
@@ -1,32 +1,32 @@ @@ -1,32 +1,32 @@
1# $NetBSD: Makefile,v 1.22 2023/08/23 15:40:13 adam Exp $ 1# $NetBSD: Makefile,v 1.23 2023/11/03 09:15:34 adam Exp $
2 2
3DISTNAME= timescaledb-2.11.2 3DISTNAME= timescaledb-2.12.1
4PKGNAME= postgresql${PGSQL_VERSION}-${DISTNAME} 4PKGNAME= postgresql${PGSQL_VERSION}-${DISTNAME}
5CATEGORIES= databases 5CATEGORIES= databases
6MASTER_SITES= ${MASTER_SITE_GITHUB:=timescale/} 6MASTER_SITES= ${MASTER_SITE_GITHUB:=timescale/}
7GITHUB_PROJECT= timescaledb 7GITHUB_PROJECT= timescaledb
8 8
9MAINTAINER= otis@NetBSD.org 9MAINTAINER= otis@NetBSD.org
10HOMEPAGE= https://github.com/timescale/timescaledb 10HOMEPAGE= https://github.com/timescale/timescaledb
11COMMENT= The timescaledb extension for PostgreSQL 11COMMENT= The timescaledb extension for PostgreSQL
12LICENSE= apache-2.0 12LICENSE= apache-2.0
13 13
14DEPENDS+= postgresql${PGSQL_VERSION}-server>=0:../../databases/postgresql${PGSQL_VERSION}-server 14DEPENDS+= postgresql${PGSQL_VERSION}-server>=0:../../databases/postgresql${PGSQL_VERSION}-server
15 15
16CMAKE_ARGS+= -DUSE_OPENSSL=ON 16CMAKE_ARGS+= -DUSE_OPENSSL=ON
17CMAKE_ARGS+= -DREGRESS_CHECKS=OFF 17CMAKE_ARGS+= -DREGRESS_CHECKS=OFF
18 18
19PGSQL_VERSIONS_ACCEPTED= 15 14 13 12 19PGSQL_VERSIONS_ACCEPTED= 15 14 13
20 20
21PKG_OPTIONS_VAR= PKG_OPTIONS.timescaledb 21PKG_OPTIONS_VAR= PKG_OPTIONS.timescaledb
22PKG_SUPPORTED_OPTIONS+= timescale-license 22PKG_SUPPORTED_OPTIONS+= timescale-license
23PKG_SUGGESTED_OPTIONS+= timescale-license 23PKG_SUGGESTED_OPTIONS+= timescale-license
24 24
25.include "../../mk/bsd.options.mk" 25.include "../../mk/bsd.options.mk"
26 26
27PLIST_VARS+= tsl 27PLIST_VARS+= tsl
28.if !empty(PKG_OPTIONS:Mtimescale-license) 28.if !empty(PKG_OPTIONS:Mtimescale-license)
29LICENSE+= AND timescale-license 29LICENSE+= AND timescale-license
30CMAKE_ARGS+= -DAPACHE_ONLY=OFF 30CMAKE_ARGS+= -DAPACHE_ONLY=OFF
31RESTRICTED= No clear permission granted to distribute 31RESTRICTED= No clear permission granted to distribute
32NO_SRC_ON_FTP= ${RESTRICTED} 32NO_SRC_ON_FTP= ${RESTRICTED}
cvs diff -r1.19 -r1.20 pkgsrc/databases/postgresql-timescaledb/PLIST (expand / switch to unified diff)

--- pkgsrc/databases/postgresql-timescaledb/PLIST 2023/08/23 15:40:13 1.19
+++ pkgsrc/databases/postgresql-timescaledb/PLIST 2023/11/03 09:15:34 1.20
@@ -1,39 +1,28 @@ @@ -1,39 +1,28 @@
1@comment $NetBSD: PLIST,v 1.19 2023/08/23 15:40:13 adam Exp $ 1@comment $NetBSD: PLIST,v 1.20 2023/11/03 09:15:34 adam Exp $
2lib/postgresql/timescaledb-${PKGVERSION}.so 2lib/postgresql/timescaledb-${PKGVERSION}.so
3${PLIST.tsl}lib/postgresql/timescaledb-tsl-${PKGVERSION}.so 3${PLIST.tsl}lib/postgresql/timescaledb-tsl-${PKGVERSION}.so
4lib/postgresql/timescaledb.so 4lib/postgresql/timescaledb.so
5share/postgresql/extension/timescaledb--${PKGVERSION}.sql 5share/postgresql/extension/timescaledb--${PKGVERSION}.sql
6share/postgresql/extension/timescaledb--1.7.0--${PKGVERSION}.sql 
7share/postgresql/extension/timescaledb--1.7.1--${PKGVERSION}.sql 
8share/postgresql/extension/timescaledb--1.7.2--${PKGVERSION}.sql 
9share/postgresql/extension/timescaledb--1.7.3--${PKGVERSION}.sql 
10share/postgresql/extension/timescaledb--1.7.4--${PKGVERSION}.sql 
11share/postgresql/extension/timescaledb--1.7.5--${PKGVERSION}.sql 
12share/postgresql/extension/timescaledb--2.0.0--${PKGVERSION}.sql 
13share/postgresql/extension/timescaledb--2.0.0-rc1--${PKGVERSION}.sql 
14share/postgresql/extension/timescaledb--2.0.0-rc2--${PKGVERSION}.sql 
15share/postgresql/extension/timescaledb--2.0.0-rc3--${PKGVERSION}.sql 
16share/postgresql/extension/timescaledb--2.0.0-rc4--${PKGVERSION}.sql 
17share/postgresql/extension/timescaledb--2.0.1--${PKGVERSION}.sql 
18share/postgresql/extension/timescaledb--2.0.2--${PKGVERSION}.sql 
19share/postgresql/extension/timescaledb--2.1.0--${PKGVERSION}.sql 6share/postgresql/extension/timescaledb--2.1.0--${PKGVERSION}.sql
20share/postgresql/extension/timescaledb--2.1.1--${PKGVERSION}.sql 7share/postgresql/extension/timescaledb--2.1.1--${PKGVERSION}.sql
21share/postgresql/extension/timescaledb--2.10.0--${PKGVERSION}.sql 8share/postgresql/extension/timescaledb--2.10.0--${PKGVERSION}.sql
22share/postgresql/extension/timescaledb--2.10.1--${PKGVERSION}.sql 9share/postgresql/extension/timescaledb--2.10.1--${PKGVERSION}.sql
23share/postgresql/extension/timescaledb--2.10.2--${PKGVERSION}.sql 10share/postgresql/extension/timescaledb--2.10.2--${PKGVERSION}.sql
24share/postgresql/extension/timescaledb--2.10.3--${PKGVERSION}.sql 11share/postgresql/extension/timescaledb--2.10.3--${PKGVERSION}.sql
25share/postgresql/extension/timescaledb--2.11.0--${PKGVERSION}.sql 12share/postgresql/extension/timescaledb--2.11.0--${PKGVERSION}.sql
26share/postgresql/extension/timescaledb--2.11.1--${PKGVERSION}.sql 13share/postgresql/extension/timescaledb--2.11.1--${PKGVERSION}.sql
 14share/postgresql/extension/timescaledb--2.11.2--${PKGVERSION}.sql
 15share/postgresql/extension/timescaledb--2.12.0--${PKGVERSION}.sql
27share/postgresql/extension/timescaledb--2.2.0--${PKGVERSION}.sql 16share/postgresql/extension/timescaledb--2.2.0--${PKGVERSION}.sql
28share/postgresql/extension/timescaledb--2.2.1--${PKGVERSION}.sql 17share/postgresql/extension/timescaledb--2.2.1--${PKGVERSION}.sql
29share/postgresql/extension/timescaledb--2.3.0--${PKGVERSION}.sql 18share/postgresql/extension/timescaledb--2.3.0--${PKGVERSION}.sql
30share/postgresql/extension/timescaledb--2.3.1--${PKGVERSION}.sql 19share/postgresql/extension/timescaledb--2.3.1--${PKGVERSION}.sql
31share/postgresql/extension/timescaledb--2.4.0--${PKGVERSION}.sql 20share/postgresql/extension/timescaledb--2.4.0--${PKGVERSION}.sql
32share/postgresql/extension/timescaledb--2.4.1--${PKGVERSION}.sql 21share/postgresql/extension/timescaledb--2.4.1--${PKGVERSION}.sql
33share/postgresql/extension/timescaledb--2.4.2--${PKGVERSION}.sql 22share/postgresql/extension/timescaledb--2.4.2--${PKGVERSION}.sql
34share/postgresql/extension/timescaledb--2.5.0--${PKGVERSION}.sql 23share/postgresql/extension/timescaledb--2.5.0--${PKGVERSION}.sql
35share/postgresql/extension/timescaledb--2.5.1--${PKGVERSION}.sql 24share/postgresql/extension/timescaledb--2.5.1--${PKGVERSION}.sql
36share/postgresql/extension/timescaledb--2.5.2--${PKGVERSION}.sql 25share/postgresql/extension/timescaledb--2.5.2--${PKGVERSION}.sql
37share/postgresql/extension/timescaledb--2.6.0--${PKGVERSION}.sql 26share/postgresql/extension/timescaledb--2.6.0--${PKGVERSION}.sql
38share/postgresql/extension/timescaledb--2.6.1--${PKGVERSION}.sql 27share/postgresql/extension/timescaledb--2.6.1--${PKGVERSION}.sql
39share/postgresql/extension/timescaledb--2.7.0--${PKGVERSION}.sql 28share/postgresql/extension/timescaledb--2.7.0--${PKGVERSION}.sql
cvs diff -r1.21 -r1.22 pkgsrc/databases/postgresql-timescaledb/distinfo (expand / switch to unified diff)

--- pkgsrc/databases/postgresql-timescaledb/distinfo 2023/08/23 15:40:13 1.21
+++ pkgsrc/databases/postgresql-timescaledb/distinfo 2023/11/03 09:15:34 1.22
@@ -1,5 +1,5 @@ @@ -1,5 +1,5 @@
1$NetBSD: distinfo,v 1.21 2023/08/23 15:40:13 adam Exp $ 1$NetBSD: distinfo,v 1.22 2023/11/03 09:15:34 adam Exp $
2 2
3BLAKE2s (timescaledb-2.11.2.tar.gz) = 332cd21ebe14c30f507041773fa7e70d08b35f19320f4beef27372e306b2645b 3BLAKE2s (timescaledb-2.12.1.tar.gz) = d94a4e557f6da33f65b10d107bc1f3d085dff560da874a3e122a2617eda73e7d
4SHA512 (timescaledb-2.11.2.tar.gz) = eb7a631c0c4f25d4faa6b24cd00185ac34a40590aecedfeadb852dbb9123e2a3e07d6a8b4c9a37861b8ef107891498f13e83a8776340e199ab9a0f1f15a35b05 4SHA512 (timescaledb-2.12.1.tar.gz) = 0b005446eab4f3b3cf1abea6ef1cbbd77a50de40402bba1a9ba5049315b4c8ecba0e45af3288c865076534b3b0eaca68cdbe31026deaca1cdb2ab5f493bfb925
5Size (timescaledb-2.11.2.tar.gz) = 7728399 bytes 5Size (timescaledb-2.12.1.tar.gz) = 7519337 bytes