Path to this page:
Subject: CVS commit: pkgsrc/databases/postgresql-timescaledb
From: Adam Ciarcinski
Date: 2023-08-02 08:38:30
Message id: 20230802063830.604C4FBDB@cvs.NetBSD.org
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
Files: