pg_partman 5.2.4 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 5.2.4 released
Date: 2025-01-07 20:17:28
Message-ID: 173628104842.818647.202629578334557073@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-announce

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](https://github.com/pgpartman/pg_partman/blob/development/CHANGELOG.md).

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](https://github.com/pgpartman/pg_partman/issues) or [pull requests](https://github.com/pgpartman/pg_partman/pulls) for any issues encountered. General questions can be submitted to [discussions](https://github.com/pgpartman/pg_partman/discussions).

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/development/doc/pg_partman.md](https://github.com/pgpartman/pg_partman/blob/development/doc/pg_partman.md)

Release Notes - [https://github.com/pgpartman/pg_partman/blob/development/CHANGELOG.md](https://github.com/pgpartman/pg_partman/blob/development/CHANGELOG.md)

Crunchy Data - [https://www.crunchydata.com](https://www.crunchydata.com)

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

Browse pgsql-announce by date

  From Date Subject
Next Message Dalibo via PostgreSQL Announce 2025-01-07 20:23:14 PostgreSQL Anonymizer 2.0: Better, Faster, Safer
Previous Message SQLPage via PostgreSQL Announce 2025-01-06 21:01:44 SQLPage v0.32: build web apps in SQL, now with more style !