Explore 2387 PostgreSQL extensions from PGEXT, maintained by Pigsty.
51 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 |
| 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 |
| 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_pathman | 1.5 | Partitioning tool for PostgreSQL | OLAP | PostgreSQL | C | 11–15 | 587 |
| duckdb_fdw | 1.4.3 | DuckDB Foreign Data Wrapper | OLAP | MIT | C | 14–18 | 409 |
| 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_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 |
| 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 |
| ppg_fdw | 1.0 | ppg_fdw: distributed parallel query engine for sharded remote PostgreSQL servers | OLAP | — | C | — | 12 |
| gogudb | 1.1 | PostgreSQL extension for distributed hash and range partitioning across foreign servers. | OLAP | PostgreSQL | C | 10–11 | 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 |
| 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 |
| 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 |
| pgrollup | 1.0 | create rollup tables for fast aggregate queries | OLAP | — | C | 12–13 | 1 |
| google_columnar_engine | — | AlloyDB column store, planner, and execution engine for accelerating HTAP and OLAP scans, joins, and aggregates. | OLAP | — | C | 14–18 | |
| 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_ocpm | 1.0.0 | Object-centric process-mining storage, traversal, aggregation, and compact analytical capsules. | OLAP | Apache-2.0 | C | 13–18 | |
| pg_shardman | 1.0 | Manages PostgreSQL 10 hash-sharded tables across nodes using pg_pathman, postgres_fdw, and logical replication. | OLAP | PostgreSQL | C | 10 | |
| rds_duckdb | 1.3.2.3 | Alibaba Cloud RDS PostgreSQL DuckDB analytical acceleration extension | OLAP | — | C | 13–18 | |
| shardman | 0.0.1 | Experimental sharding, rebalance, and cross-node lock-graph prototype | OLAP | — | C | — |