Explore 2387 PostgreSQL extensions from PGEXT, maintained by Pigsty.
70 extensions found. Clear filters
| Name | Version | Description | Category | License | Language | PG Version | Stars |
|---|---|---|---|---|---|---|---|
| pg_lakehouse | 0.7.6 | An analytical query engine for PostgreSQL | OLAP | AGPL-3.0 | Rust | 14–16 | 9.2k |
| 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 |
| cstore_fdw | 1.7 | Columnar storage extension for PostgreSQL built as a foreign data wrapper | OLAP | Apache-2.0 | C | 10–12 | 1.8k |
| 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_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 |
| 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 |
| falcon | 1.0 | FalconFS is a high-performance distributed file system (DFS) designed for AI workloads. | OLAP | MulanPSL-2.0 | C++ | — | 66 |
| 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 |
| 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 |
| 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_table_range | 0.1.1 | Planning-time partition pruning by per-partition data ranges, including non-key columns. | OLAP | MIT | Rust | 16–18 | 2 |
| pg_trex | 0.1.0 | pg trex: PostgreSQL extension for distributed trexsql | OLAP | — | Rust | — | 2 |
| pgparts | 0.0.15 | SQL/PLpgSQL helper extension for creating and maintaining table partitions with triggers | OLAP | BSD-3-Clause | SQL | — | 2 |
| data_rig | 1.0 | Multidimensional OLAP fact data type with GiST indexing support. | OLAP | — | C | — | 1 |
| heapy | 1.0 | table AM for Yezzey | OLAP | — | C | — | 1 |
| mypg_sharding | 0.0.1 | mypg sharding utilities for PostgreSQL | OLAP | — | C | — | 1 |
| pg_prttn_tools | 0.5 | Provides PL/pgSQL tools for managing inheritance-based partition tables. | OLAP | MIT | SQL | — | 1 |
| pg_xarray | 0.2.0 | Catalog and query layer for chunked scientific arrays (NetCDF, Zarr, HDF5, GRIB, COG, SELAFIN, MED, CGNS, FITS) | OLAP | — | Rust | — | 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 |
| 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 |
| autocluster | 1.7.0 | EDB table access method that preserves clustering locality during inserts. | OLAP | Proprietary | — | — | |
| bluefin | 1.7.0 | Append-only compressed table access method for time-series workloads. | OLAP | Proprietary | — | 15–18 | |
| dventimi@pg_partition_magician | 0.1.0 | Pure-SQL online RANGE-partition manager (time / id / uuidv7), pg_cron-driven | OLAP | — | SQL | — |