Explore 2387 PostgreSQL extensions from PGEXT, maintained by Pigsty.
95 extensions found. Clear filters
| Name | Version | Description | Category | License | Language | PG Version | Stars |
|---|---|---|---|---|---|---|---|
| citus | 14.2.0 | Distributed PostgreSQL as an extension | OLAP | AGPL-3.0 | C | 16–18 | 13k |
| citus_columnar | 14.2.0 | Citus columnar storage engine | OLAP | AGPL-3.0 | C | 16–18 | 13k |
| pg_lakehouse | 0.7.6 | An analytical query engine for PostgreSQL | OLAP | AGPL-3.0 | Rust | 14–16 | 9.2k |
| pg_duckdb | 1.1.1 | DuckDB Embedded in Postgres | OLAP | MIT | C++ | 14–18 | 3.2k |
| columnar | 1.1.2 | Hydra Columnar extension | OLAP | AGPL-3.0 | C | 14–16 | 3.0k |
| pg_partman | 5.5.0 | Extension to manage partitioned tables by time or ID | OLAP | PostgreSQL | C | 14–18 | 2.8k |
| pipelinedb | 1.1.0 | Run continuous SQL queries for high-throughput incremental time-series aggregation in PostgreSQL | OLAP | Apache-2.0 | C | 10–11 | 2.7k |
| pg_mooncake | 0.2.0 | Columnstore Table in Postgres | OLAP | MIT | Rust | 14–18 | 2.0k |
| cstore_fdw | 1.7 | Columnar storage extension for PostgreSQL built as a foreign data wrapper | OLAP | Apache-2.0 | C | 10–12 | 1.8k |
| pg_extension_base | 3.5 | Extension development kit by Snowflake | OLAP | Apache-2.0 | C | 16–18 | 1.6k |
| pg_extension_updater | 3.5 | Automatic extension updater | OLAP | Apache-2.0 | C | 16–18 | 1.6k |
| pg_lake | 3.5 | Data lake extension by Snowflake | OLAP | Apache-2.0 | C | 16–18 | 1.6k |
| pg_lake_copy | 3.5 | Copy to/from data lake files | OLAP | Apache-2.0 | C | 16–18 | 1.6k |
| pg_lake_engine | 3.5 | Query engine for data lake queries | OLAP | Apache-2.0 | C | 16–18 | 1.6k |
| pg_lake_iceberg | 3.5 | Iceberg implementation in Postgres | OLAP | Apache-2.0 | C | 16–18 | 1.6k |
| pg_lake_table | 3.5 | Data lake tables and Iceberg tables | OLAP | Apache-2.0 | C | 16–18 | 1.6k |
| pg_map | 3.5 | Map type for PostgreSQL, bundled as a required pg_lake component. | OLAP | Apache-2.0 | C | 16–18 | 1.6k |
| pg_strom | 6.1 | PG-Strom - big-data processing acceleration using GPU and NVME | OLAP | PostgreSQL | C | 15–18 | 1.4k |
| interconnect | 1.0 | One advanced and mature open-source MPP (Massively Parallel Processing) database. Open source alternative to Greenplum Database. | OLAP | Apache-2.0 | C | — | 1.4k |
| pg_shard | 1.2 | Shard and replicate PostgreSQL tables across remote servers | OLAP | LGPL-3.0 | C | — | 1.1k |
| pg_parquet | 0.5.1 | copy data between Postgres and Parquet | OLAP | PostgreSQL | Rust | 14–18 | 685 |
| pg_pathman | 1.5 | Partitioning tool for PostgreSQL | OLAP | PostgreSQL | C | 11–15 | 587 |
| pg_analytics | 0.3.7 | Postgres for analytics, powered by DuckDB | OLAP | PostgreSQL | Rust | 14–17 | 540 |
| duckdb_fdw | 1.4.3 | DuckDB Foreign Data Wrapper | OLAP | MIT | C | 14–18 | 409 |
| pg_clickhouse | 0.10.0 | Interfaces to query ClickHouse databases from PostgreSQL | OLAP | Apache-2.0 | C++ | 14–18 | 280 |
| pgfdb | 0.0.2 | Experimental pgrx extension that stores PostgreSQL table and index data in FoundationDB for distributed, fault-tolerant, horizontally scalable operation. | OLAP | AGPL-3.0 | Rust | 13–17 | 227 |
| imcs | 1.1 | In-Memory Columnar Store extension for PostgreSQL. | OLAP | Apache-2.0 | C | — | 202 |
| plproxy | 2.12.0 | Database partitioning implemented as procedural language | OLAP | ISC | C | 14–18 | 198 |
| vops | 1.1 | Vectorized tile types, aggregates, projections, and FDW for PostgreSQL OLAP | OLAP | PostgreSQL | C | — | 163 |
| quack | 0.0.1 | DuckDB Embedded in Postgres | OLAP | Apache-2.0 | C | 14–15 | 151 |
| pg_ducklake | 1.0.0 | DuckLake lakehouse extension for PostgreSQL, backed by DuckDB and Parquet | OLAP | MIT | C++ | 14–18 | 130 |
| falcon | 1.0 | FalconFS is a high-performance distributed file system (DFS) designed for AI workloads. | OLAP | MulanPSL-2.0 | C++ | — | 66 |
| pg_sorted_heap | 0.14.0 | Sorted heap table AM with zone map scan pruning and built-in vector search | OLAP | PostgreSQL | C | 16–18 | 60 |
| coldfront | 1.0 | Transparent hot and cold tiering between PostgreSQL partitions and writable Apache Iceberg tables | OLAP | PostgreSQL | C | 16–18 | 48 |
| yezzey | 1.8.11 | Offload Greenplum and Cloudberry append-only tables to S3 | OLAP | PostgreSQL | C++ | — | 40 |
| pgcolumnar | 1.0-alpha4 | Native column-oriented table access method with compression, vectorized scans, and Parquet workflows. | OLAP | MIT | C | 15–19 | 35 |
| pg_cryogen | 0.1 | Experimental append-only compressed table access method for PostgreSQL 12 and later. | OLAP | PostgreSQL | C | 12–18 | 32 |
| storage_engine | 2.4.0 | colcompress and rowcompress Table Access Methods with vectorized execution | OLAP | AGPL-3.0 | C | 15–18 | 31 |
| vectorize_engine | 1.0 | Vectorized query execution extension for PostgreSQL | OLAP | PostgreSQL | C | — | 29 |
| chdb | 0.1 | Execute isolated chDB queries from PostgreSQL through a helper process | OLAP | Apache-2.0 | C | 15–19 | 20 |
| 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 |
| ppg_fdw | 1.0 | ppg_fdw: distributed parallel query engine for sharded remote PostgreSQL servers | OLAP | — | C | — | 12 |
| pg_fusion | 24.0.0 | Experimental PostgreSQL extension for DataFusion-backed analytical query execution | OLAP | BSD-2-Clause | Rust | 17 | 10 |
| pg_orca | 1.0.0 | ORCA query optimizer as a PostgreSQL extension | OLAP | Apache-2.0 | C++ | 18 | 8 |
| gogudb | 1.1 | PostgreSQL extension for distributed hash and range partitioning across foreign servers. | OLAP | PostgreSQL | C | 10–11 | 7 |
| pg_partition | 0.2.0 | Generate and manage timestamp-based PostgreSQL table partitions | OLAP | MIT | SQL | 10–18 | 7 |
| pg_particulous | 1.0 | Migrate tables between vanilla PostgreSQL and pg_pathman partitioning | OLAP | — | C | — | 6 |
| router | 0.0.1 | Experimental C extension that routes PostgreSQL OLTP queries across shards. | OLAP | PostgreSQL | C | — | 6 |
| koldstore | 0.1.0 | PostgreSQL tiered-storage that moves historical rows to Parquet while keeping the original table fully queryable and supporting updates and deletes. | OLAP | Apache-2.0 | Rust | — | 5 |