Subject: CVS commit: pkgsrc/databases/postgresql-timescaledb
From: Adam Ciarcinski
Date: 2024-11-08 14:46:49
Message id: 20241108134649.55B31FC7E@cvs.NetBSD.org

Log Message:
postgresql-timescaledb: updated to 2.17.2

2.17.2 (2024-11-06)

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

Bugfixes

Fix "negative bitmapset member not allowed" and performance degradation
on queries to compressed tables with ORDER BY clause matching the order of the
compressed data
Use-after-free in vectorized grouping by segmentby columns

2.17.1 (2024-10-21)

This release contains performance improvements and bug fixes since the 2.17.0 \ 
release. We recommend that you upgrade at the next available opportunity.

Features

Add chunk skipping GUC
Bugfixes

Change log level used in compression
Fix collation for in-memory tuple filtering

2.17.0 (2024-10-08)

This release adds support for PostgreSQL 17, significantly improves the \ 
performance of continuous aggregate refreshes, and contains performance \ 
improvements for analytical queries and delete operations over compressed \ 
hypertables.
We recommend that you upgrade at the next available opportunity.

Highlighted features in TimescaleDB v2.17.0

Full PostgreSQL 17 support for all existing features. TimescaleDB v2.17 is \ 
available for PostgreSQL 14, 15, 16, and 17.

Significant performance improvements for continuous aggregate policies:
Continuous aggregate refresh is now using merge instead of deleting old \ 
materialized data and re-inserting. This update can decrease dramatically the \ 
amount of data that must be written on the continuous aggregate in the presence \ 
of a small number of changes, reduce the i/o cost of refreshing a continuous \ 
aggregate, and generate fewer Write-Ahead Logs (WAL). Overall, continuous \ 
aggregate policies will be more lightweight, use less system resources, and \ 
complete faster.

Increased performance for real-time analytical queries over compressed hypertables:
We are excited to introduce additional Single Instruction, Multiple Data (SIMD) \ 
vectorization optimization to our engine by supporting vectorized execution for \ 
queries that group by using the segment_by column(s) and aggregate using the \ 
basic aggregate functions (sum, count, avg, min, max).
Stay tuned for more to come in follow-up releases! Support for grouping
on additional columns, filtered aggregation,
vectorized expressions, and time_bucket is coming soon.

Improved performance of deletes on compressed hypertables when a large amount of \ 
data is affected.
This improvement speeds up operations that delete whole segments by skipping the \ 
decompression step. It is enabled for all deletes that filter by the segment_by \ 
column(s).

Files:
RevisionActionfile
1.35modifypkgsrc/databases/postgresql-timescaledb/Makefile
1.31modifypkgsrc/databases/postgresql-timescaledb/PLIST
1.33modifypkgsrc/databases/postgresql-timescaledb/distinfo