select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Extensions / Analytics

dventimi@pg_partition_magician

Pure-SQL online RANGE-partition manager (time / id / uuidv7), pg_cron-driven

pgext.cloud · Website

Overview

Packagedventimi@pg_partition_magician
Version0.1.0
RepositoryUnspecified
Extension typeSQL only
Project statusActive
Requires CREATE EXTENSIONYes
Requires preloadNo
Catalogue updated2026-07-30

Related extensions

Requires

pg_cronJob scheduler for PostgreSQL

See also

pg_cronJob scheduler for PostgreSQL
pg_dispatchAsynchronous SQL dispatcher built on pg_cron
pgagentA PostgreSQL job scheduler
pg_kpartReject full partition scans that omit the partition key
cron_utilsParse cron expressions and compute previous or next trigger times
pg_taskexecute any sql command at any specific time at background
tab_tierPL/pgSQL extension for job-driven retention, tiering, and date-based table partition maintenance.
mpartmanModern partition manager for PostgreSQL