Subject: CVS commit: pkgsrc/databases/postgresql-timescaledb
From: Adam Ciarcinski
Date: 2023-11-03 10:15:34
Message id: 20231103091534.4B5B4FA2B@cvs.NetBSD.org

Log Message:
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

Files:
RevisionActionfile
1.23modifypkgsrc/databases/postgresql-timescaledb/Makefile
1.20modifypkgsrc/databases/postgresql-timescaledb/PLIST
1.22modifypkgsrc/databases/postgresql-timescaledb/distinfo