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.

citus · Distributed PostgreSQL as an extension · 14.2.0 · Analytics · AGPL-3.0 · C · Packagedpg_lakehouse · An analytical query engine for PostgreSQL · 0.7.6 · Analytics · AGPL-3.0 · Rust · Not packagedpg_duckdb · DuckDB Embedded in Postgres · 1.1.1 · Analytics · MIT · C++ · Packagedpg_partman · Extension to manage partitioned tables by time or ID · 5.5.0 · Analytics · PostgreSQL · C · Packagedpipelinedb · Run continuous SQL queries for high-throughput incremental time-series aggregation in PostgreSQL · 1.1.0 · Analytics · Apache-2.0 · C · Not packagedpg_mooncake · Columnstore Table in Postgres · 0.2.0 · Analytics · MIT · Rust · Packagedcstore_fdw · Columnar storage extension for PostgreSQL built as a foreign data wrapper · 1.7 · Analytics · Apache-2.0 · C · Not packagedpg_extension_base · Extension development kit by Snowflake · 3.5 · Analytics · Apache-2.0 · C · Packagedpg_lake · Data lake extension by Snowflake · 3.5 · Analytics · Apache-2.0 · C · Packagedpg_lake_copy · Copy to/from data lake files · 3.5 · Analytics · Apache-2.0 · C · Packagedpg_lake_iceberg · Iceberg implementation in Postgres · 3.5 · Analytics · Apache-2.0 · C · Packagedpg_map · Map type for PostgreSQL, bundled as a required pg_lake component. · 3.5 · Analytics · Apache-2.0 · C · Packagedpg_strom · PG-Strom - big-data processing acceleration using GPU and NVME · 6.1 · Analytics · PostgreSQL · C · 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_parquet · copy data between Postgres and Parquet · 0.5.1 · Analytics · PostgreSQL · Rust · 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 packagedpg_clickhouse · Interfaces to query ClickHouse databases from PostgreSQL · 0.10.0 · Analytics · Apache-2.0 · C++ · 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 packagedpg_ducklake · DuckLake lakehouse extension for PostgreSQL, backed by DuckDB and Parquet · 1.0.0 · Analytics · MIT · C++ · Packagedpg_sorted_heap · Sorted heap table AM with zone map scan pruning and built-in vector search · 0.14.0 · Analytics · PostgreSQL · C · 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 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 packagedpg_orca · ORCA query optimizer as a PostgreSQL extension · 1.0.0 · Analytics · Apache-2.0 · C++ · 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_trex · pg trex: PostgreSQL extension for distributed trexsql · 0.1.0 · Analytics · Unknown · Rust · Not packagedmypg_sharding · mypg sharding utilities for PostgreSQL · 0.0.1 · Analytics · Unknown · C · 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 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_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 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 packagedtablefunc · functions that manipulate whole tables, including crosstab · 1.0 · Analytics · PostgreSQL · C · Packaged

61 extensions found. Clear filters

NameVersionDescriptionCategoryLicenseLanguagePG VersionStars
mypg_sharding 0.0.1 mypg sharding utilities for PostgreSQL OLAP C 1
pgrollup 1.0 create rollup tables for fast aggregate queries OLAP C 12–13 1
range_partitioning 1.2.2 Manages trigger-based static range partitions for PostgreSQL-XL, including split and merge operations. OLAP PostgreSQL SQL 1
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_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
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
tablefunc 1.0 functions that manipulate whole tables, including crosstab OLAP PostgreSQL C 14–18