PostgreSQL Extension Catalogue

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
pg_mooncake	0.2.0	Columnstore Table in Postgres	OLAP	MIT	Rust	14–18	2.0k
pg_parquet	0.5.1	copy data between Postgres and Parquet	OLAP	PostgreSQL	Rust	14–18	685
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
pg_fusion	24.0.0	Experimental PostgreSQL extension for DataFusion-backed analytical query execution	OLAP	BSD-2-Clause	Rust	17	10
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
pg_substrait	0.1.0	Execute Substrait protobuf or JSON query plans through PostgreSQL functions	OLAP	PostgreSQL	Rust	13–17	4
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
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
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_tier	0.0.5	Tier PostgreSQL table data to external S3 storage through parquet_s3_fdw.	OLAP	Apache-2.0	Rust	14–16
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
th_dbdm	1.3.3	th dbdm: Postgres for database data management	OLAP	—	Rust	—

pg_lakehouse

0.7.6

An analytical query engine for PostgreSQL

14–16

0.2.0

Columnstore Table in Postgres

14–18

0.5.1

copy data between Postgres and Parquet

14–18

0.3.7

Postgres for analytics, powered by DuckDB

14–17

0.0.2

Experimental pgrx extension that stores PostgreSQL table and index data in FoundationDB for distributed, fault-tolerant, horizontally scalable operation.

13–17

24.0.0

Experimental PostgreSQL extension for DataFusion-backed analytical query execution

OLAP

BSD-2-Clause

Rust

17