pg_partman ☆
« Back to VersTracker
Description:
Partition management extension for PostgreSQL
Type: Formula  |  Latest Version: 5.3.1@0  |  Tracked Since: Oct 20, 2025
Links: Homepage  |  formulae.brew.sh
Category: Databases
Tags: postgresql partitioning database extension maintenance
Install: brew install pg_partman
About:
pg_partman is a PostgreSQL extension designed to automate and manage table partitioning. It simplifies the creation and maintenance of partition sets, handling the creation of child tables and the dynamic partitioning of data as it is inserted. This extension is essential for managing large datasets by improving query performance and data retention policies.
Key Features:
  • Automatic partition creation
  • Background worker for maintenance
  • Support for time and id-based partitioning
  • Simplified data retention management
Use Cases:
  • Managing large-scale time-series data in PostgreSQL
  • Improving query performance on big tables
  • Automating data archival and deletion
Alternatives:
  • pg_cron – Often used alongside pg_partman to schedule maintenance jobs, but does not handle partitioning logic itself.
Version History
Detected Version Rev Change Commit
Oct 20, 2025 5:18pm 0 VERSION_BUMP 3087f940
Oct 9, 2025 2:26pm 0 VERSION_BUMP d440e9a3
Sep 24, 2025 7:37pm 0 VERSION_BUMP db210c59
Jan 3, 2025 12:00am 0 VERSION_BUMP 7fef96cf
Dec 30, 2024 8:40pm 0 VERSION_BUMP a1a55f89
Dec 30, 2024 8:11pm 0 VERSION_BUMP 75c6a40d
Sep 27, 2024 8:03pm 0 VERSION_BUMP 684d75b8
« Back to VersTracker  |  Browse Packages  |  About