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.

pg_lakehouse · An analytical query engine for PostgreSQL · 0.7.6 · Analytics · AGPL-3.0 · Rust · Not packagedpipelinedb · Run continuous SQL queries for high-throughput incremental time-series aggregation in PostgreSQL · 1.1.0 · Analytics · Apache-2.0 · C · Not packagedcstore_fdw · Columnar storage extension for PostgreSQL built as a foreign data wrapper · 1.7 · Analytics · Apache-2.0 · C · Not packagedinterconnect · One advanced and mature open-source MPP (Massively Parallel Processing) database. Open source alternative to Greenplum Database. · 1.0 · Analytics · Apache-2.0 · C · Not packagedpg_shard · Shard and replicate PostgreSQL tables across remote servers · 1.2 · Analytics · LGPL-3.0 · C · Not packagedpg_pathman · Partitioning tool for PostgreSQL · 1.5 · Analytics · PostgreSQL · C · Not packagedpg_analytics · Postgres for analytics, powered by DuckDB · 0.3.7 · Analytics · PostgreSQL · Rust · Not packagedpgfdb · Experimental pgrx extension that stores PostgreSQL table and index data in FoundationDB for distributed, fault-tolerant, horizontally scalable operation. · 0.0.2 · Analytics · AGPL-3.0 · Rust · Not packagedimcs · In-Memory Columnar Store extension for PostgreSQL. · 1.1 · Analytics · Apache-2.0 · C · Not packagedvops · Vectorized tile types, aggregates, projections, and FDW for PostgreSQL OLAP · 1.1 · Analytics · PostgreSQL · C · Not packagedquack · DuckDB Embedded in Postgres · 0.0.1 · Analytics · Apache-2.0 · C · Not packagedfalcon · FalconFS is a high-performance distributed file system (DFS) designed for AI workloads. · 1.0 · Analytics · MulanPSL-2.0 · C++ · Not packagedcoldfront · Transparent hot and cold tiering between PostgreSQL partitions and writable Apache Iceberg tables · 1.0 · Analytics · PostgreSQL · C · Not packagedyezzey · Offload Greenplum and Cloudberry append-only tables to S3 · 1.8.11 · Analytics · PostgreSQL · C++ · Not packagedpgcolumnar · Native column-oriented table access method with compression, vectorized scans, and Parquet workflows. · 1.0-alpha4 · Analytics · MIT · C · Not packagedpg_cryogen · Experimental append-only compressed table access method for PostgreSQL 12 and later. · 0.1 · Analytics · PostgreSQL · C · Not packagedvectorize_engine · Vectorized query execution extension for PostgreSQL · 1.0 · Analytics · PostgreSQL · C · Not packagedchdb · Execute isolated chDB queries from PostgreSQL through a helper process · 0.1 · Analytics · Apache-2.0 · C · Not packagedmpartman · 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 packagedppg_fdw · ppg_fdw: distributed parallel query engine for sharded remote PostgreSQL servers · 1.0 · Analytics · Unknown · C · Not packagedpg_fusion · Experimental PostgreSQL extension for DataFusion-backed analytical query execution · 24.0.0 · Analytics · BSD-2-Clause · Rust · Not packagedgogudb · PostgreSQL extension for distributed hash and range partitioning across foreign servers. · 1.1 · Analytics · PostgreSQL · C · Not packagedpg_partition · Generate and manage timestamp-based PostgreSQL table partitions · 0.2.0 · Analytics · MIT · SQL · Not packagedpg_particulous · Migrate tables between vanilla PostgreSQL and pg_pathman partitioning · 1.0 · Analytics · Unknown · C · Not packagedrouter · Experimental C extension that routes PostgreSQL OLTP queries across shards. · 0.0.1 · Analytics · PostgreSQL · C · Not packagedkoldstore · PostgreSQL tiered-storage that moves historical rows to Parquet while keeping the original table fully queryable and supporting updates and deletes. · 0.1.0 · Analytics · Apache-2.0 · Rust · Not packagedpartman_to_cstore · Move old pg_partman partitions to cstore columnar storage. · 1.1.0 · Analytics · PostgreSQL · SQL · Not packagedpg_substrait · Execute Substrait protobuf or JSON query plans through PostgreSQL functions · 0.1.0 · Analytics · PostgreSQL · Rust · Not packagedpmpp · Run manually partitioned SQL work in parallel over asynchronous libpq connections and combine the results · 1.2.3 · Analytics · PostgreSQL · C · Not packagedrepeater · Demonstration extension for executing serialized raw query plans on a remote PostgreSQL node. · 0.1 · Analytics · PostgreSQL · C · Not packagedpathman_sharding · Improved sharding for pg_pathman. · 0.1 · Analytics · PostgreSQL · C · Not packagedpargres · Prototype parallel query execution module for shared-nothing PostgreSQL clusters · 0.1 · Analytics · PostgreSQL · C · Not packagedpg_delta_am · Delta table access method skeleton · 0.1.0 · Analytics · Apache-2.0 · Rust · Not packagedpg_iceberg_am · Iceberg table developed by Robert Mu · 0.1.0 · Analytics · Apache-2.0 · Rust · Not packagedpg_lakebase_runtime · Shared runtime for Lakebase table access method extensions · 0.1.0 · Analytics · Apache-2.0 · Rust · Not packagedpg_table_range · Planning-time partition pruning by per-partition data ranges, including non-key columns. · 0.1.1 · Analytics · MIT · Rust · Not packagedpg_trex · pg trex: PostgreSQL extension for distributed trexsql · 0.1.0 · Analytics · Unknown · Rust · Not packagedpgparts · SQL/PLpgSQL helper extension for creating and maintaining table partitions with triggers · 0.0.15 · Analytics · BSD-3-Clause · SQL · Not packageddata_rig · Multidimensional OLAP fact data type with GiST indexing support. · 1.0 · Analytics · Unknown · C · Not packagedheapy · table AM for Yezzey · 1.0 · Analytics · Unknown · C · Not packagedmypg_sharding · mypg sharding utilities for PostgreSQL · 0.0.1 · Analytics · Unknown · C · Not packagedpg_prttn_tools · Provides PL/pgSQL tools for managing inheritance-based partition tables. · 0.5 · Analytics · MIT · SQL · Not packagedpg_xarray · Catalog and query layer for chunked scientific arrays (NetCDF, Zarr, HDF5, GRIB, COG, SELAFIN, MED, CGNS, FITS) · 0.2.0 · Analytics · Unknown · Rust · Not packagedpgrollup · create rollup tables for fast aggregate queries · 1.0 · Analytics · Unknown · C · 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 packagedautocluster · EDB table access method that preserves clustering locality during inserts. · 1.7.0 · Analytics · Proprietary · Unknown · Not packagedbluefin · Append-only compressed table access method for time-series workloads. · 1.7.0 · Analytics · Proprietary · Unknown · Not packageddventimi@pg_partition_magician · Pure-SQL online RANGE-partition manager (time / id / uuidv7), pg_cron-driven · 0.1.0 · Analytics · Unknown · SQL · Not packagedgoogle_columnar_engine · AlloyDB column store, planner, and execution engine for accelerating HTAP and OLAP scans, joins, and aggregates. · Analytics · Unknown · C · Not packagednarugn · A lightweight distributed computer · 0.3.0 · Analytics · GPL-3.0 · SQL · Not packagedoptimized_row_format · Experimental table access method for compact, cache-friendly row storage. · 1.0 · Analytics · Unknown · C · Not packagedorochi · Modern HTAP PostgreSQL extension for sharding, time-series, columnar analytics, tiered storage, and vector workloads. · 1.0 · Analytics · Unknown · C · Not packagedpg_acce · pg_acce -- Accelerated Engine · 1.0 · Analytics · GPL-2.0 · C · Not packagedpg_elephantduck · Columnar PostgreSQL table access method powered by DuckDB and Parquet storage. · 0.0.0 · Analytics · MIT · Rust · Not packagedpg_mooncake_rust · pg mooncake rust: Columnstore table in Postgres · 0.0.1 · Analytics · Unknown · Rust · Not packagedpg_ocpm · Object-centric process-mining storage, traversal, aggregation, and compact analytical capsules. · 1.0.0 · Analytics · Apache-2.0 · C · 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 packagedpg_shardman · Manages PostgreSQL 10 hash-sharded tables across nodes using pg_pathman, postgres_fdw, and logical replication. · 1.0 · Analytics · PostgreSQL · C · Not packagedpg_tier · Tier PostgreSQL table data to external S3 storage through parquet_s3_fdw. · 0.0.5 · Analytics · Apache-2.0 · Rust · Not packagedpg_yaap · YAAP optimizer + executor integration prototype · 1.0 · Analytics · Apache-2.0 · C++ · Not packagedpgaa · Vectorized lakehouse queries over Parquet, Delta Lake, and Iceberg data. · 1.11.0 · Analytics · Proprietary · Unknown · Not packagedpgduck_rs · pgrx prototype extension that uses DuckDB to read Parquet files and return rows as JSONB in PostgreSQL. · 0.0.0 · Analytics · Unknown · Rust · Not packagedrds_duckdb · Alibaba Cloud RDS PostgreSQL DuckDB analytical acceleration extension · 1.3.2.3 · Analytics · Unknown · C · Not packagedrefdata · EDB table access method for frequently read, rarely changed reference data. · 1.7.0 · Analytics · Proprietary · Unknown · Not packagedshardman · Experimental sharding, rebalance, and cross-node lock-graph prototype · 0.0.1 · Analytics · Unknown · C · Not packagedspq · Spq Share-nothing parallel query · 2.0.0 · Analytics · AGPL-3.0 · C++ · 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 packagedth_dbdm · th dbdm: Postgres for database data management · 1.3.3 · Analytics · Unknown · Rust · Not packaged

70 extensions found. Clear filters

NameVersionDescriptionCategoryLicenseLanguagePG VersionStars
google_columnar_engine AlloyDB column store, planner, and execution engine for accelerating HTAP and OLAP scans, joins, and aggregates. OLAP C 14–18
narugn 0.3.0 A lightweight distributed computer OLAP GPL-3.0 SQL
optimized_row_format 1.0 Experimental table access method for compact, cache-friendly row storage. OLAP C 17
orochi 1.0 Modern HTAP PostgreSQL extension for sharding, time-series, columnar analytics, tiered storage, and vector workloads. OLAP C 16–18
pg_acce 1.0 pg_acce -- Accelerated Engine OLAP GPL-2.0 C
pg_elephantduck 0.0.0 Columnar PostgreSQL table access method powered by DuckDB and Parquet storage. OLAP MIT Rust 16–17
pg_mooncake_rust 0.0.1 pg mooncake rust: Columnstore table in Postgres OLAP Rust
pg_ocpm 1.0.0 Object-centric process-mining storage, traversal, aggregation, and compact analytical capsules. OLAP Apache-2.0 C 13–18
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
pg_shardman 1.0 Manages PostgreSQL 10 hash-sharded tables across nodes using pg_pathman, postgres_fdw, and logical replication. OLAP PostgreSQL C 10
pg_tier 0.0.5 Tier PostgreSQL table data to external S3 storage through parquet_s3_fdw. OLAP Apache-2.0 Rust 14–16
pg_yaap 1.0 YAAP optimizer + executor integration prototype OLAP Apache-2.0 C++
pgaa 1.11.0 Vectorized lakehouse queries over Parquet, Delta Lake, and Iceberg data. OLAP Proprietary 16–18
pgduck_rs 0.0.0 pgrx prototype extension that uses DuckDB to read Parquet files and return rows as JSONB in PostgreSQL. OLAP Rust 13–18
rds_duckdb 1.3.2.3 Alibaba Cloud RDS PostgreSQL DuckDB analytical acceleration extension OLAP C 13–18
refdata 1.7.0 EDB table access method for frequently read, rarely changed reference data. OLAP Proprietary
shardman 0.0.1 Experimental sharding, rebalance, and cross-node lock-graph prototype OLAP C
spq 2.0.0 Spq Share-nothing parallel query OLAP AGPL-3.0 C++
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
th_dbdm 1.3.3 th dbdm: Postgres for database data management OLAP Rust