PIGSTY

OLAP

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

OLAP category contains 13 PostgreSQL extensions.

IDExtensionPackageVersionDescription
2400cituscitus13.1.0Distributed PostgreSQL as an extension
2401citus_columnarcitus13.1.0Citus columnar storage engine
2410columnarhydra1.1.2Hydra Columnar extension
2420pg_analyticspg_analytics0.3.7Postgres for analytics, powered by DuckDB
2430pg_duckdbpg_duckdb0.3.1DuckDB Embedded in Postgres
2440pg_mooncakepg_mooncake0.1.2Columnstore Table in Postgres
2450duckdb_fdwduckdb_fdw1.1.2DuckDB Foreign Data Wrapper
2460pg_parquetpg_parquet0.4.0copy data between Postgres and Parquet
2500pg_fkpartpg_fkpart1.7.0Table partitioning by foreign key utility
2510pg_partmanpg_partman5.2.4Extension to manage partitioned tables by time or ID
2520plproxyplproxy2.11.0Database partitioning implemented as procedural language
2530pg_strompg_strom6.0PG-Strom - big-data processing acceleration using GPU and NVME
2590tablefunctablefunc1.0functions that manipulate whole tables, including crosstab

citus - 13.1.0

Distributed PostgreSQL as an extension

ExtensionWebsiteAttributes
Packagecitus
LOAD
RPMcitus_$v*
DDL
DEBpostgresql-$v-citus
LIB
Language
C
License
AGPL-3.0
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

citus_columnar - 13.1.0

Citus columnar storage engine

ExtensionWebsiteAttributes
Packagecitus
RPMcitus_$v*
DDL
DEBpostgresql-$v-citus
LIB
Language
C
License
AGPL-3.0
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

columnar - 1.1.2

Hydra Columnar extension

ExtensionWebsiteAttributes
Packagehydra
RPMhydra_$v*
DDL
DEBpostgresql-$v-hydra
LIB
Language
C
License
AGPL-3.0
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pg_analytics - 0.3.7

Postgres for analytics, powered by DuckDB

ExtensionWebsiteAttributes
Packagepg_analytics
RPMpg_analytics_$v
DDL
DEBpostgresql-$v-pg-analytics
LIB
Language
Rust
License
PostgreSQL
TRUST
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pg_duckdb - 0.3.1

DuckDB Embedded in Postgres

ExtensionWebsiteAttributes
Packagepg_duckdb
LOAD
RPMpg_duckdb_$v*
DDL
DEBpostgresql-$v-pg-duckdb
LIB
Language
C++
License
MIT
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pg_mooncake - 0.1.2

Columnstore Table in Postgres

ExtensionWebsiteAttributes
Packagepg_mooncake
RPMpg_mooncake_$v*
DDL
DEBpostgresql-$v-pg-mooncake
Language
C++
License
MIT
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

duckdb_fdw - 1.1.2

DuckDB Foreign Data Wrapper

ExtensionWebsiteAttributes
Packageduckdb_fdw
RPMduckdb_fdw_$v*
DDL
DEBpostgresql-$v-duckdb-fdw
LIB
Language
C
License
MIT
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pg_parquet - 0.4.0

copy data between Postgres and Parquet

ExtensionWebsiteAttributes
Packagepg_parquet
LOAD
RPMpg_parquet_$v
DDL
DEBpostgresql-$v-pg-parquet
LIB
Language
Rust
License
PostgreSQL
TRUST
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pg_fkpart - 1.7.0

Table partitioning by foreign key utility

ExtensionWebsiteAttributes
Packagepg_fkpart
RPMpg_fkpart_$v
DDL
DEBpostgresql-$v-pg-fkpart
Language
SQL
License
GPL-2.0
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pg_partman - 5.2.4

Extension to manage partitioned tables by time or ID

ExtensionWebsiteAttributes
Packagepg_partman
RPMpg_partman_$v*
DDL
DEBpostgresql-$v-partman
LIB
Language
C
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

plproxy - 2.11.0

Database partitioning implemented as procedural language

ExtensionWebsiteAttributes
Packageplproxy
RPMplproxy_$v*
DDL
DEBpostgresql-$v-plproxy
LIB
Language
C
License
BSD 0-Clause
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

pg_strom - 6.0

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

ExtensionWebsiteAttributes
Packagepg_strom
RPMpg_strom_$v*
DDL
DEBN/A
LIB
Language
C
License
PostgreSQL
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

tablefunc - 1.0

functions that manipulate whole tables, including crosstab

ExtensionWebsiteAttributes
Packagetablefunc
RPMpostgresql$v-contrib
DDL
DEBpostgresql-$v
LIB
Language
C
License
PostgreSQL
TRUST
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13