select open change scope Open full search

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

PostgreSQL Extension Catalogue

Explore 2387 PostgreSQL extensions from PGEXT, maintained by Pigsty.

mpartman · Modern partition manager for PostgreSQL · 0.1.1 · Analytics · MIT-0 · SQL · Not packagedpg_part · Table partitioning utility for PostgreSQL · 0.1.0 · Analytics · GPL-2.0 · SQL · Not packagedpg_partition · Generate and manage timestamp-based PostgreSQL table partitions · 0.2.0 · Analytics · MIT · SQL · Not packagedpg_fkpart · Table partitioning by foreign key utility · 1.7.0 · Analytics · GPL-2.0 · SQL · Packagedpartman_to_cstore · Move old pg_partman partitions to cstore columnar storage. · 1.1.0 · Analytics · PostgreSQL · SQL · Not packagedpgparts · SQL/PLpgSQL helper extension for creating and maintaining table partitions with triggers · 0.0.15 · Analytics · BSD-3-Clause · SQL · Not packagedpg_prttn_tools · Provides PL/pgSQL tools for managing inheritance-based partition tables. · 0.5 · Analytics · MIT · SQL · Not packagedrange_partitioning · Manages trigger-based static range partitions for PostgreSQL-XL, including split and merge operations. · 1.2.2 · Analytics · PostgreSQL · SQL · Not packagedshard_manager · SQL/PLpgSQL toolkit for schema-based sharding, shard maps, template-table cloning, and 64-bit distributed ID generation. · 0.0.1 · Analytics · Apache-2.0 · SQL · Not packageddventimi@pg_partition_magician · Pure-SQL online RANGE-partition manager (time / id / uuidv7), pg_cron-driven · 0.1.0 · Analytics · Unknown · SQL · Not packagednarugn · A lightweight distributed computer · 0.3.0 · Analytics · GPL-3.0 · SQL · Not packagedpg_popyramids_datamarts · Creates population-pyramid analytics data-mart objects in a hard-coded dms schema from a pre-existing ods schema. · 1.0.0 · Analytics · GPL-3.0 · SQL · Not packagedtab_tier · PL/pgSQL extension for job-driven retention, tiering, and date-based table partition maintenance. · 1.1 · Analytics · Apache-2.0 · SQL · Not packaged

13 extensions found. Clear filters

NameVersionDescriptionCategoryLicenseLanguagePG VersionStars
mpartman 0.1.1 Modern partition manager for PostgreSQL OLAP MIT-0 SQL 17
pg_part 0.1.0 Table partitioning utility for PostgreSQL OLAP GPL-2.0 SQL 14
pg_partition 0.2.0 Generate and manage timestamp-based PostgreSQL table partitions OLAP MIT SQL 10–18 7
pg_fkpart 1.7.0 Table partitioning by foreign key utility OLAP GPL-2.0 SQL 14–18 5
partman_to_cstore 1.1.0 Move old pg_partman partitions to cstore columnar storage. OLAP PostgreSQL SQL 10–18 4
pgparts 0.0.15 SQL/PLpgSQL helper extension for creating and maintaining table partitions with triggers OLAP BSD-3-Clause SQL 2
pg_prttn_tools 0.5 Provides PL/pgSQL tools for managing inheritance-based partition tables. OLAP MIT SQL 1
range_partitioning 1.2.2 Manages trigger-based static range partitions for PostgreSQL-XL, including split and merge operations. OLAP PostgreSQL SQL 1
shard_manager 0.0.1 SQL/PLpgSQL toolkit for schema-based sharding, shard maps, template-table cloning, and 64-bit distributed ID generation. OLAP Apache-2.0 SQL 1
dventimi@pg_partition_magician 0.1.0 Pure-SQL online RANGE-partition manager (time / id / uuidv7), pg_cron-driven OLAP SQL
narugn 0.3.0 A lightweight distributed computer OLAP GPL-3.0 SQL
pg_popyramids_datamarts 1.0.0 Creates population-pyramid analytics data-mart objects in a hard-coded dms schema from a pre-existing ods schema. OLAP GPL-3.0 SQL
tab_tier 1.1 PL/pgSQL extension for job-driven retention, tiering, and date-based table partition maintenance. OLAP Apache-2.0 SQL 10–18