Modern partition manager for PostgreSQL
pgext.cloud · Source code · Documentation · Control file
| Package | mpartman |
|---|---|
| Version | 0.1.1 |
| Repository | Unspecified |
| Extension type | Standard |
| Project status | Active |
| Requires CREATE EXTENSION | Yes |
| Requires preload | No |
| Trusted | No |
| Relocatable | No |
| Stars | 17 |
| Latest commit | 2023-05-18 |
| Catalogue updated | 2026-08-30 |
| pg_kpart | Reject full partition scans that omit the partition key |
| dventimi@pg_partition_magician | Pure-SQL online RANGE-partition manager (time / id / uuidv7), pg_cron-driven |
| pg_table_range | Planning-time partition pruning by per-partition data ranges, including non-key columns. |
| pg_prttn_tools | Provides PL/pgSQL tools for managing inheritance-based partition tables. |
| tab_tier | PL/pgSQL extension for job-driven retention, tiering, and date-based table partition maintenance. |
| reject_partition_fullscan | Reject queries that scan every partition without pruning. |
| alohadb_timeseries | Auto-partition management for time-series tables using a background worker |
| plproxy | Database partitioning implemented as procedural language |