Explore 2387 PostgreSQL extensions from PGEXT, maintained by Pigsty.
61 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 |
| 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 |
| 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_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_iceberg | 3.5 | Iceberg implementation in Postgres | 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 |
| 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 |
| 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 |
| 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 |
| pg_cryogen | 0.1 | Experimental append-only compressed table access method for PostgreSQL 12 and later. | OLAP | PostgreSQL | C | 12–18 | 32 |
| 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 |
| partman_to_cstore | 1.1.0 | Move old pg_partman partitions to cstore columnar storage. | OLAP | PostgreSQL | SQL | 10–18 | 4 |
| pg_substrait | 0.1.0 | Execute Substrait protobuf or JSON query plans through PostgreSQL functions | OLAP | PostgreSQL | Rust | 13–17 | 4 |
| pmpp | 1.2.3 | Run manually partitioned SQL work in parallel over asynchronous libpq connections and combine the results | OLAP | PostgreSQL | C | 10 | 4 |
| repeater | 0.1 | Demonstration extension for executing serialized raw query plans on a remote PostgreSQL node. | OLAP | PostgreSQL | C | 12 | 4 |
| pathman_sharding | 0.1 | Improved sharding for pg_pathman. | OLAP | PostgreSQL | C | 10 | 3 |
| pargres | 0.1 | Prototype parallel query execution module for shared-nothing PostgreSQL clusters | OLAP | PostgreSQL | C | — | 2 |
| pg_delta_am | 0.1.0 | Delta table access method skeleton | OLAP | Apache-2.0 | Rust | — | 2 |
| pg_iceberg_am | 0.1.0 | Iceberg table developed by Robert Mu | OLAP | Apache-2.0 | Rust | — | 2 |
| pg_lakebase_runtime | 0.1.0 | Shared runtime for Lakebase table access method extensions | OLAP | Apache-2.0 | Rust | — | 2 |
| pg_trex | 0.1.0 | pg trex: PostgreSQL extension for distributed trexsql | OLAP | — | Rust | — | 2 |