Explore 2387 PostgreSQL extensions from PGEXT, maintained by Pigsty.
95 extensions found. Clear filters
| Name | Version | Description | Category | License | Language | PG Version | Stars |
|---|---|---|---|---|---|---|---|
| pg_fkpart | 1.7.0 | Table partitioning by foreign key utility | OLAP | GPL-2.0 | SQL | 14–18 | 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 | — | |
| google_columnar_engine | — | AlloyDB column store, planner, and execution engine for accelerating HTAP and OLAP scans, joins, and aggregates. | OLAP | — | C | 14–18 | |
| narugn | 0.3.0 | A lightweight distributed computer | OLAP | GPL-3.0 | SQL | — | |
| 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_elephantduck | 0.0.0 | Columnar PostgreSQL table access method powered by DuckDB and Parquet storage. | OLAP | MIT | Rust | 16–17 | |
| pg_mooncake_rust | 0.0.1 | pg mooncake rust: Columnstore table in Postgres | OLAP | — | Rust | — | |
| pg_ocpm | 1.0.0 | Object-centric process-mining storage, traversal, aggregation, and compact analytical capsules. | OLAP | Apache-2.0 | C | 13–18 | |
| pg_popyramids_datamarts | 1.0.0 | Creates population-pyramid analytics data-mart objects in a hard-coded dms schema from a pre-existing ods schema. | OLAP | GPL-3.0 | SQL | — | |
| 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 | |
| pg_yaap | 1.0 | YAAP optimizer + executor integration prototype | OLAP | Apache-2.0 | C++ | — | |
| pgaa | 1.11.0 | Vectorized lakehouse queries over Parquet, Delta Lake, and Iceberg data. | OLAP | Proprietary | — | 16–18 | |
| 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 | |
| refdata | 1.7.0 | EDB table access method for frequently read, rarely changed reference data. | OLAP | Proprietary | — | — | |
| shardman | 0.0.1 | Experimental sharding, rebalance, and cross-node lock-graph prototype | OLAP | — | C | — | |
| spq | 2.0.0 | Spq Share-nothing parallel query | OLAP | AGPL-3.0 | C++ | — | |
| tab_tier | 1.1 | PL/pgSQL extension for job-driven retention, tiering, and date-based table partition maintenance. | OLAP | Apache-2.0 | SQL | 10–18 | |
| tablefunc | 1.0 | functions that manipulate whole tables, including crosstab | OLAP | PostgreSQL | C | 14–18 | |
| th_dbdm | 1.3.3 | th dbdm: Postgres for database data management | OLAP | — | Rust | — |