PostgreSQL Extension Catalogue

Name	Version	Description	Category	License	Language	PG Version	Stars
pg_partman	5.5.0	Extension to manage partitioned tables by time or ID	OLAP	PostgreSQL	C	14–18	2.8k
pg_strom	6.1	PG-Strom - big-data processing acceleration using GPU and NVME	OLAP	PostgreSQL	C	15–18	1.4k
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
vops	1.1	Vectorized tile types, aggregates, projections, and FDW for PostgreSQL OLAP	OLAP	PostgreSQL	C	—	163
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
gogudb	1.1	PostgreSQL extension for distributed hash and range partitioning across foreign servers.	OLAP	PostgreSQL	C	10–11	7
router	0.0.1	Experimental C extension that routes PostgreSQL OLTP queries across shards.	OLAP	PostgreSQL	C	—	6
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
range_partitioning	1.2.2	Manages trigger-based static range partitions for PostgreSQL-XL, including split and merge operations.	OLAP	PostgreSQL	SQL	—	1
pg_shardman	1.0	Manages PostgreSQL 10 hash-sharded tables across nodes using pg_pathman, postgres_fdw, and logical replication.	OLAP	PostgreSQL	C	10
tablefunc	1.0	functions that manipulate whole tables, including crosstab	OLAP	PostgreSQL	C	14–18

pg_partman

5.5.0

Extension to manage partitioned tables by time or ID

14–18

6.1

PG-Strom - big-data processing acceleration using GPU and NVME

OLAP