Subject: CVS commit: pkgsrc/databases/postgresql-timescaledb
From: Adam Ciarcinski
Date: 2024-01-22 10:10:14
Message id: 20240122091015.067ABFA42@cvs.NetBSD.org

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

Files:
RevisionActionfile
1.24modifypkgsrc/databases/postgresql-timescaledb/Makefile
1.21modifypkgsrc/databases/postgresql-timescaledb/PLIST
1.23modifypkgsrc/databases/postgresql-timescaledb/distinfo