pg_partman 4.6.0 released

From: Crunchy Data via PostgreSQL Announce <announce-noreply(at)postgresql(dot)org>
To: PostgreSQL Announce <pgsql-announce(at)lists(dot)postgresql(dot)org>
Subject: pg_partman 4.6.0 released
Date: 2021-10-13 00:57:39
Message-ID: 163408665969.679.17192622662932963100@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-announce

PostgreSQL Partition Manager (pg_partman) v4.6.0 has been released.

**IMPORTANT REQUEST**: A topic has been opened on the github page to discuss the future development of pg_partman and support for trigger-based partitioning. A plan is currently in place to begin dropping trigger-based support upon the EOL for PostgreSQL 10 on November 10, 2022. Feedback is requested for use-cases that could potentially change these plans and continue supporting trigger-based partitioning until native partitioning better supports them.

[https://github.com/pgpartman/pg_partman/discussions/360](https://github.com/pgpartman/pg_partman/discussions/360)

Version 4.6.0 brings significantly better support for partitioning with arbitrary time interval values. Other changes of note are:

- PostgreSQL 14 support
- Deprecation of pg_partman's specialized UPSERT support for PG 11 and greater. Usage of the built-in INSERT ... ON CONFLICT feature is better supported in native partitioning as of version 11.
- When dropping child tables for retention, DROP ... CASCADE is no longer supported in native partitioning. This avoids the foreign key references to the partition set being dropped completely whenever a child table is dropped.
- Additional features and bug fixes for this release can be found in the CHANGELOG.

Links:

Website - [https://github.com/pgpartman/pg_partman](https://github.com/pgpartman/pg_partman)
Installation - [https://github.com/pgpartman/pg_partman#installation](https://github.com/pgpartman/pg_partman#installation)
Documentation - [https://github.com/pgpartman/pg_partman/blob/master/doc/pg_partman.md](https://github.com/pgpartman/pg_partman/blob/master/doc/pg_partman.md)
Release Notes - [https://github.com/pgpartman/pg_partman/blob/master/CHANGELOG.txt](https://github.com/pgpartman/pg_partman/blob/master/CHANGELOG.txt)
Crunchy Data - [https://www.crunchydata.com](https://www.crunchydata.com)

Crunchy Data is proud to support the development and maintenance of pg_partman.

--
Keith Fiske
Senior Database Engineer
Crunchy Data

Browse pgsql-announce by date

  From Date Subject
Next Message Microsoft Azure via PostgreSQL Announce 2021-10-18 00:14:04 PostgreSQL 14 available in production on Azure in Hyperscale (Citus)
Previous Message United States PostgreSQL Association via PostgreSQL Announce 2021-10-13 00:57:04 PGConf NYC 2021 Sessions Announced, Last Week for Early Bird!