OLAP - Analytics

DuckDB Integration with FDW & PG Lakehouse, Access Parquet from File/S3, Sharding with Citus/Partman/PlProxy, …

Extension List

There are 14 extensions in 13 packages.

ExtensionPackageVersionLicenseLanguageDescription
cituscitus14.0.0AGPL-3.0CDistributed PostgreSQL as an extension
citus_columnarcitus14.0.0AGPL-3.0CCitus columnar storage engine
columnarhydra1.1.2AGPL-3.0CHydra Columnar extension
pg_analyticspg_analytics0.3.7PostgreSQLRustPostgres for analytics, powered by DuckDB
pg_duckdbpg_duckdb1.1.1MITC++DuckDB Embedded in Postgres
pg_mooncakepg_mooncake0.2.0MITRustColumnstore Table in Postgres
pg_clickhousepg_clickhouse0.1.4Apache-2.0C++Interfaces to query ClickHouse databases from PostgreSQL
duckdb_fdwduckdb_fdw1.1.2MITCDuckDB Foreign Data Wrapper
pg_parquetpg_parquet0.5.1PostgreSQLRustcopy data between Postgres and Parquet
pg_fkpartpg_fkpart1.7.0GPL-2.0SQLTable partitioning by foreign key utility
pg_partmanpg_partman5.4.3PostgreSQLCExtension to manage partitioned tables by time or ID
plproxyplproxy2.11.0BSD 0-ClauseCDatabase partitioning implemented as procedural language
pg_strompg_strom6.1PostgreSQLCPG-Strom - big-data processing acceleration using GPU and NVME
tablefunctablefunc1.0PostgreSQLCfunctions that manipulate whole tables, including crosstab

citus

citus - 14.0.0 : Distributed PostgreSQL as an extension

ItemValueOSx86_64aarch64
Extensioncitusel818171615141817161514
Packagecitusel918171615141817161514
RPMcitus_$vel1018171615141817161514
DEBpostgresql-$v-citusd1218171615141817161514
LanguageCd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicenseAGPL-3.0u2418171615141817161514

citus_columnar

citus - 14.0.0 : Citus columnar storage engine

ItemValueOSx86_64aarch64
Extensioncitus_columnarel818171615141817161514
Packagecitusel918171615141817161514
RPMcitus_$vel1018171615141817161514
DEBpostgresql-$v-citusd1218171615141817161514
LanguageCd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicenseAGPL-3.0u2418171615141817161514

columnar

hydra - 1.1.2 : Hydra Columnar extension

ItemValueOSx86_64aarch64
Extensioncolumnarel818171615141817161514
Packagehydrael918171615141817161514
RPMhydra_$vel1018171615141817161514
DEBpostgresql-$v-hydrad1218171615141817161514
LanguageCd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicenseAGPL-3.0u2418171615141817161514

pg_analytics

pg_analytics - 0.3.7 : Postgres for analytics, powered by DuckDB

ItemValueOSx86_64aarch64
Extensionpg_analyticsel818171615141817161514
Packagepg_analyticsel918171615141817161514
RPMpg_analytics_$vel10--
DEBpostgresql-$v-pg-analyticsd1218171615141817161514
LanguageRustd13--
RepoPIGSTYu2218171615141817161514
LicensePostgreSQLu2418171615141817161514

pg_duckdb

pg_duckdb - 1.1.1 : DuckDB Embedded in Postgres

ItemValueOSx86_64aarch64
Extensionpg_duckdbel818171615141817161514
Packagepg_duckdbel918171615141817161514
RPMpg_duckdb_$vel1018171615141817161514
DEBpostgresql-$v-pg-duckdbd1218171615141817161514
LanguageC++d1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicenseMITu2418171615141817161514

pg_mooncake

pg_mooncake - 0.2.0 : Columnstore Table in Postgres

ItemValueOSx86_64aarch64
Extensionpg_mooncakeel818171615141817161514
Packagepg_mooncakeel918171615141817161514
RPMpg_mooncake_$vel1018171615141817161514
DEBpostgresql-$v-pg-mooncaked1218171615141817161514
LanguageRustd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicenseMITu2418171615141817161514

pg_clickhouse

pg_clickhouse - 0.1.4 : Interfaces to query ClickHouse databases from PostgreSQL

ItemValueOSx86_64aarch64
Extensionpg_clickhouseel818171615141817161514
Packagepg_clickhouseel918171615141817161514
RPMpg_clickhouse_$vel1018171615141817161514
DEBpostgresql-$v-clickhoused1218171615141817161514
LanguageC++d1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicenseApache-2.0u2418171615141817161514

duckdb_fdw

duckdb_fdw - 1.1.2 : DuckDB Foreign Data Wrapper

ItemValueOSx86_64aarch64
Extensionduckdb_fdwel818171615141817161514
Packageduckdb_fdwel918171615141817161514
RPMduckdb_fdw_$vel10--
DEBpostgresql-$v-duckdb-fdwd1218171615141817161514
LanguageCd13--
RepoPIGSTYu2218171615141817161514
LicenseMITu2418171615141817161514

pg_parquet

pg_parquet - 0.5.1 : copy data between Postgres and Parquet

ItemValueOSx86_64aarch64
Extensionpg_parquetel818171615141817161514
Packagepg_parquetel918171615141817161514
RPMpg_parquet_$vel1018171615141817161514
DEBpostgresql-$v-pg-parquetd1218171615141817161514
LanguageRustd1318171615141817161514
RepoPIGSTYu2218171615141817161514
LicensePostgreSQLu2418171615141817161514

pg_fkpart

pg_fkpart - 1.7.0 : Table partitioning by foreign key utility

ItemValueOSx86_64aarch64
Extensionpg_fkpartel818171615141817161514
Packagepg_fkpartel918171615141817161514
RPMpg_fkpart_$vel1018171615141817161514
DEBpostgresql-$v-pg-fkpartd1218171615141817161514
LanguageSQLd1318171615141817161514
RepoMIXEDu2218171615141817161514
LicenseGPL-2.0u2418171615141817161514

pg_partman

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

ItemValueOSx86_64aarch64
Extensionpg_partmanel818171615141817161514
Packagepg_partmanel918171615141817161514
RPMpg_partman_$vel1018171615141817161514
DEBpostgresql-$v-partmand1218171615141817161514
LanguageCd1318171615141817161514
RepoPGDGu2218171615141817161514
LicensePostgreSQLu2418171615141817161514

plproxy

plproxy - 2.11.0 : Database partitioning implemented as procedural language

ItemValueOSx86_64aarch64
Extensionplproxyel818171615141817161514
Packageplproxyel918171615141817161514
RPMplproxy_$vel1018171615141817161514
DEBpostgresql-$v-plproxyd1218171615141817161514
LanguageCd1318171615141817161514
RepoPGDGu2218171615141817161514
LicenseBSD 0-Clauseu2418171615141817161514

pg_strom

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

ItemValueOSx86_64aarch64
Extensionpg_stromel81817161514-
Packagepg_stromel91817161514-
RPMpg_strom_$vel101817161514-
DEB-d12--
LanguageCd13--
RepoPGDGu22--
LicensePostgreSQLu24--

tablefunc

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

ItemValueOSx86_64aarch64
Extensiontablefuncel818171615141817161514
Packagetablefuncel918171615141817161514
RPMpostgresql$v-contribel1018171615141817161514
DEBpostgresql-$vd1218171615141817161514
LanguageCd1318171615141817161514
RepoCONTRIBu2218171615141817161514
LicensePostgreSQLu2418171615141817161514

Last Modified 2026-03-12: add pg extension catalog (95749bf)