Category: OLAP

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

OLAP category has 13 available extensions:

Name (Detail)	Package (Repo)	Repo	Version	Category	License	Description
citus	`citus`	PIGSTY	13.0.1	`OLAP`	AGPLv3	Distributed PostgreSQL as an extension
citus_columnar	`citus`	PIGSTY	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.3.3	`OLAP`	PostgreSQL	Postgres for analytics, powered by DuckDB
pg_duckdb	`pg_duckdb`	PIGSTY	0.2.0	`OLAP`	MIT	DuckDB Embedded in Postgres
pg_mooncake	`pg_mooncake`	PIGSTY	0.1.0	`OLAP`	MIT	Columnstore Table in Postgres
duckdb_fdw	`duckdb_fdw`	PIGSTY	1.1.2	`OLAP`	MIT	DuckDB Foreign Data Wrapper
pg_parquet	`pg_parquet`	PIGSTY	0.2.0	`OLAP`	PostgreSQL	copy data between Postgres and Parquet
pg_fkpart	`pg_fkpart`	MIXED	1.7	`OLAP`	GPLv2	Table partitioning by foreign key utility
pg_partman	`pg_partman`	PGDG	5.2.4	`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