pg_partman is a PostgreSQL extension for managing time-based and serial-based table partitioning. It automates the creation, maintenance, and retention of partitions, making it easier to manage large datasets with better performance and query efficiency. Designed for both native and trigger-based partitioning, pg_partman is ideal for applications handling time-series or log data.
Features
- Automates time and serial-based table partitioning
- Supports native and trigger-based partitioning
- Background worker for automatic partition creation
- Retention policy to drop or archive old partitions
- Partition template system for schema consistency
- Supports subpartitioning for complex data structures
Categories
DatabaseFollow pg_partman
Other Useful Business Software
Our Free Plans just got better! | Auth0
You asked, we delivered! Auth0 is excited to expand our Free and Paid plans to include more options so you can focus on building, deploying, and scaling applications without having to worry about your security. Auth0 now, thank yourself later.
Rate This Project
Login To Rate This Project
User Reviews
Be the first to post a review of pg_partman!