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.
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 ! |