Category: OLAP

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

OLAP category has 12 available extensions:

Extension (URL)	Alias	Repo	Version	Category	License	Description
citus	`citus`	PGDG	12.1-1	`OLAP`	AGPLv3	Distributed PostgreSQL as an extension
citus_columnar	`citus`	PGDG	11.3-1	`OLAP`	AGPLv3	Citus columnar storage engine
columnar	`hydra`	PIGSTY	11.1-11	`OLAP`	AGPLv3	Hydra Columnar extension
pg_analytics	`pg_analytics`	PIGSTY	0.1.1	`OLAP`	AGPLv3	Postgres for analytics, powered by DuckDB
pg_lakehouse	`pg_lakehouse`	PIGSTY	0.9.0	`OLAP`	AGPLv3	pg_lakehouse: An analytical query engine for Postgres
pg_duckdb	`pg_duckdb`	PIGSTY	0.0.1	`OLAP`	MIT	DuckDB Embedded in Postgres
duckdb_fdw	`duckdb_fdw`	PIGSTY	1.0.0	`OLAP`	MIT	DuckDB Foreign Data Wrapper
parquet_s3_fdw	`parquet_s3_fdw`	PIGSTY	0.3.1	`OLAP`	MIT	foreign-data wrapper for parquet on S3
pg_fkpart	`pg_fkpart`	PGDG	1.7	`OLAP`	GPLv2	Table partitioning by foreign key utility
pg_partman	`pg_partman`	PGDG	5.1.0	`OLAP`	PostgreSQL	Extension to manage partitioned tables by time or ID
plproxy	`plproxy`	PGDG	2.11.0	`OLAP`	BSD 0	Database partitioning implemented as procedural language
pg_strom	`pg_strom`	PGDG	5.1	`OLAP`	PostgreSQL	PG-Strom - big-data processing acceleration using GPU and NVME
tablefunc	`tablefunc`	CONTRIB	1.0	`OLAP`	PostgreSQL	functions that manipulate whole tables, including crosstab