OLAP - Analytics

Extension List

There are 25 extensions in 17 packages.

citus

citus - 14.1.0 : Distributed PostgreSQL as an extension

citus_columnar

citus - 14.1.0 : Citus columnar storage engine

columnar

hydra - 1.1.2 : Hydra Columnar extension

pg_duckdb

pg_duckdb - 1.1.1 : DuckDB Embedded in Postgres

pg_mooncake

pg_mooncake - 0.2.0 : Columnstore Table in Postgres

storage_engine

storage_engine - 2.4.0 : colcompress and rowcompress Table Access Methods with vectorized execution

pg_clickhouse

pg_clickhouse - 0.3.2 : Interfaces to query ClickHouse databases from PostgreSQL

duckdb_fdw

duckdb_fdw - 1.4.3 : DuckDB Foreign Data Wrapper

pg_parquet

pg_parquet - 0.5.1 : copy data between Postgres and Parquet

pg_ducklake

pg_ducklake - 1.0.0 : DuckLake lakehouse extension for PostgreSQL, backed by DuckDB and Parquet

pg_fkpart

pg_fkpart - 1.7.0 : Table partitioning by foreign key utility

pg_partman

pg_partman - 5.5.0 : Extension to manage partitioned tables by time or ID

plproxy

plproxy - 2.12.0 : Database partitioning implemented as procedural language

pg_strom

pg_strom - 6.1 : PG-Strom - big-data processing acceleration using GPU and NVME

pg_orca

pg_orca - 1.0.0 : ORCA query optimizer as a PostgreSQL extension

pg_sorted_heap

pg_sorted_heap - 0.14.0 : Sorted heap table AM with zone map scan pruning and built-in vector search

pg_lake

pg_lake - 3.4 : Data lake extension by Snowflake

pg_extension_base

pg_lake - 3.4 : Extension development kit by Snowflake

pg_extension_updater

pg_lake - 3.4 : Automatic extension updater

pg_map

pg_lake - 3.4 : Map type for PostgreSQL, bundled as a required pg_lake component.

pg_lake_engine

pg_lake - 3.4 : Query engine for data lake queries

pg_lake_iceberg

pg_lake - 3.4 : Iceberg implementation in Postgres

pg_lake_table

pg_lake - 3.4 : Data lake tables and Iceberg tables

pg_lake_copy

pg_lake - 3.4 : Copy to/from data lake files

tablefunc

tablefunc - 1.0 : functions that manipulate whole tables, including crosstab