分类: OLAP

Distributed PostgreSQL as an extension

Citus columnar storage engine

Hydra Columnar extension

Postgres for analytics, powered by DuckDB

DuckDB Embedded in Postgres

Columnstore Table in Postgres

colcompress and rowcompress Table Access Methods with vectorized execution

Interfaces to query ClickHouse databases from PostgreSQL

DuckDB Foreign Data Wrapper

copy data between Postgres and Parquet

DuckLake lakehouse extension for PostgreSQL, backed by DuckDB and Parquet

Table partitioning by foreign key utility

Extension to manage partitioned tables by time or ID

Database partitioning implemented as procedural language

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

ORCA query optimizer as a PostgreSQL extension

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

Data lake extension by Snowflake

Extension development kit by Snowflake

Automatic extension updater

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

Query engine for data lake queries

Iceberg implementation in Postgres

Data lake tables and Iceberg tables

Copy to/from data lake files

Planning-time partition pruning by per-partition data ranges, including non-key columns.

Incremental multidimensional models and formula functions over PostgreSQL tables.

functions that manipulate whole tables, including crosstab