select open change scope Open full search

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

Extensions / Analytics

pg_partition

Generate and manage timestamp-based PostgreSQL table partitions

pgext.cloud · Source code · Documentation · License text · Control file

Overview

Packagepg_partition
Version0.2.0
PostgreSQL versions10 · 11 · 12 · 13 · 14 · 15 · 16 · 17 · 18
RepositoryUnspecified
Extension typeSQL only
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableYes
Stars7
Latest commit2014-03-25
Catalogue updated2026-08-30

Related extensions

See also

tab_tierPL/pgSQL extension for job-driven retention, tiering, and date-based table partition maintenance.
pgpartsSQL/PLpgSQL helper extension for creating and maintaining table partitions with triggers
partman_to_cstoreMove old pg_partman partitions to cstore columnar storage.
edb_foreignkeyconstraintmanagerManage trigger-based foreign-key behavior for partitioned tables on EDB Postgres Advanced Server
pg_prttn_toolsProvides PL/pgSQL tools for managing inheritance-based partition tables.
gogudbPostgreSQL extension for distributed hash and range partitioning across foreign servers.
pg_particulousMigrate tables between vanilla PostgreSQL and pg_pathman partitioning
pathman_shardingImproved sharding for pg_pathman.