The next major release of PG Partition Manager (pg_partman) has been released. Version 4.0.0 brings support for new native partitioning features found in PostgreSQL 11. It also introduces the use of stored procedures to replace some of the previous functionality that could only be accomplished with external python scripts (Ex. efficient partitioning and unpartitioning of large data sets).
Some other changes include:
- Redesigned required privileges so SECURITY DEFINER is no longer in use with many of pg_partman's functions. This is the first step in removing the superuser requirement for native partitioning all-together from this extension in the near future.
- Automatic creation of a DEFAULT partition for PG11+ native partitioning
- New source table parameter to the partitioning functions to allow easier partitioning of an existing table to a native partition set.
See the CHANGELOG for full details and additional bug fixes.