pg_partman 5.2.4 released

Crunchy Data is proud to announce the release of pg_partman 5.2.4.

Highlights of the version 5.2 release:

• Support UUIDv7 and other custom encoded methods of time-based partitioning. This allows a texted based partition column to be used as long as the value can also be encoded to some time-based value.
• Removed superuser requirement for installation.
• Improved maintenance performance.
• Fixed issues with BIGINT data type when using LIST partitioning.

Further changes and bug fixes can be found in the CHANGELOG.

About pg_partman:

pg_partman is an extension to create and manage both time-based and number-based table partition sets. As of version 5.0.0, only built-in, declarative partitioning is supported and the older trigger-based methods have been deprecated.

The declarative partitioning built into PostgreSQL provides the commands to create a partitioned table and its children, but it does not provide a means of automating that child table maintenance over time (Ex. adding new children, dropping old ones based on a retention policy). It also does not provide a means to easily turn an existing table into a partitioned table or vice versa. pg_partman aims to use the built-in declarative features that PostgreSQL provides, but build upon them to provide those missing features as well as many others to help make managing partitions easier.

Please submit issues or pull requests for any issues encountered. General questions can be submitted to discussions.

Links:

Website - https://github.com/pgpartman/pg_partman

Installation - https://github.com/pgpartman/pg_partman#installation

Documentation - https://github.com/pgpartman/pg_partman/blob/development/doc/pg_partman.md

Release Notes - https://github.com/pgpartman/pg_partman/blob/development/CHANGELOG.md

Crunchy Data - https://www.crunchydata.com

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