pgpartman/pg_partman

Health v2 · maintenance only

Flags: no_license

Adoption not part of the score

2797 stars · 316 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-29, confidence not recorded

pg_partman is a PostgreSQL extension that creates and manages time-based and number-based table partition sets using built-in declarative partitioning. It automates partition maintenance such as creating new child tables and dropping old ones via retention policies, including a background worker that runs maintenance without an external scheduler.

Use cases

• automatically create and drop time-based partitions in postgres
• manage partition retention policies for large tables
• convert an existing table into a partitioned table
• run partition maintenance without cron using a background worker
• set up numeric range partitioning for postgres tables
• migrate legacy trigger-based partitioning to declarative partitioning

When to choose

• you need automated creation and retirement of postgres table partitions over time
• you want declarative partitioning with retention policies and minimal external scheduling
• you are migrating large existing tables to partitioned layouts in postgres

When to avoid

• you use a database other than postgresql
• you need trigger-based (pre-10) partitioning methods, which are deprecated
• your tables are small enough that partitioning adds unnecessary complexity

Facets

library · maturity stable

database scheduling developer-tools databases developer-tools self-hosted postgresql-extension table-partitioning declarative-partitioning background-worker plpgsql retention-policy data-engineering postgresql linux

Member repositories

For agents

markdown · JSON · MCP: product_card(name="pgpartman/pg_partman")