PostgreSQL Partition Manager (pg_partman)
pg_partman is a powerful PostgreSQL extension designed for creating and managing both time-based and number-based table partitions. It leverages PostgreSQL's built-in declarative partitioning capabilities while providing additional automation and ease of use for partition maintenance, making it ideal for users looking to streamline their database partitioning strategies.
Features
Automates child table management and maintenance tasks with a background worker process.
Supports conversion of existing tables to partitioned tables and vice versa.
Facilitates migration from trigger-based to declarative partitioning seamlessly.
Compatible with PostgreSQL versions 14 and above, including Amazon RDS.
Provides comprehensive documentation and support through GitHub for issues and discussions.