pg_partman
A PostgreSQL extension that automates the creation and maintenance of time-based and number-based table partitions.
What is pg_partman?
pg_partman is a PostgreSQL extension that automates the management of partitioned tables. It builds upon PostgreSQL's native declarative partitioning to handle routine maintenance tasks like creating new partitions and dropping old ones based on retention policies, significantly reducing manual administrative overhead for large-scale data management.
Database administrators and developers managing large PostgreSQL databases with partitioned tables, particularly those dealing with time-series or high-volume data requiring automated lifecycle management.
Developers choose pg_partman because it provides built-in automation for partition maintenance, including a background worker that eliminates dependency on external schedulers like cron, and offers robust tools for migrating existing tables to partitioned setups, extending PostgreSQL's native partitioning with production-ready management features.
Overview
Partition management extension for PostgreSQL
Use Cases
Best For
- Automating the creation and deletion of time-based partitions (e.g., daily or monthly tables) in PostgreSQL without manual scripting.
Related Projects
Found a gem we're missing?
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
