select open change scope Open full search

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

Extensions / Analytics

pgparts

SQL/PLpgSQL helper extension for creating and maintaining table partitions with triggers

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

Overview

Packagepgparts
Version0.0.15
RepositoryUnspecified
Extension typeSQL only
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableNo
Stars2
Latest commit2019-03-14
Latest release2019-03-14
Catalogue updated2026-08-30

Related extensions

Requires

plpgsqlPL/pgSQL procedural language

See also

pg_partitionGenerate and manage timestamp-based PostgreSQL table partitions
partman_to_cstoreMove old pg_partman partitions to cstore columnar storage.
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
tab_tierPL/pgSQL extension for job-driven retention, tiering, and date-based table partition maintenance.
pathman_shardingImproved sharding for pg_pathman.
pg_table_rangePlanning-time partition pruning by per-partition data ranges, including non-key columns.