pg_partman 4.6.0 released

Posted on 2021-10-13 by Crunchy Data
Related Open Source

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.

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.


Website -
Installation -
Documentation -
Release Notes -
Crunchy Data -

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

Keith Fiske
Senior Database Engineer
Crunchy Data