This is the multi-page printable view of this section. Click here to print.

Return to the regular view of this page.

Category: OLAP

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

1: citus
2: columnar
3: pg_analytics
4: pg_lakehouse
5: pg_duckdb
6: duckdb_fdw
7: pg_parquet
8: pg_fkpart
9: pg_partman
10: plproxy
11: pg_strom
12: tablefunc

OLAP category has 11 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.2.1	`OLAP`	AGPLv3	Postgres for analytics, powered by DuckDB
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
pg_parquet	`pg_parquet`	PIGSTY	0.1.0	`OLAP`	PostgreSQL	copy data between Postgres and Parquet
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

1 - citus

Distributed PostgreSQL as an extension

Overview

PGDG 1st Party Extension: citus : Distributed PostgreSQL as an extension

Information

ID: 1500
Name: citus
Alias: citus
Category: OLAP
Website: https://github.com/citusdata/citus
License: AGPLv3 License
Language: Unknown
Tags: N/A
Comment: 无

Metadata

Version: 12.1-1
PG Vers: 16,15,14,13,12
Need Load: Explicit Loading Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Relocatable
Trusted: Untrusted, Require Superuser to Create
Schemas: pg_catalog
Requires: N/A

Packages

RPM Repo: PGDG
RPM Name: citus_$v*
RPM Ver : 12.1-1
RPM Deps: Nil
DEB Repo: PGDG
DEB Name: postgresql-$v-citus-12.1
DEB Ver : 12.1-1
DEB Deps: Nil

Details

2 - columnar

Hydra Columnar extension

Overview

PIGSTY 3rd Party Extension: hydra : Hydra Columnar extension

Information

ID: 1510
Name: columnar
Alias: hydra
Category: OLAP
Website: https://github.com/hydradatabase/hydra
License: AGPLv3 License
Language: Unknown
Tags: N/A
Comment: 无

Metadata

Version: 11.1-11
PG Vers: 16,15,14,13
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Relocatable
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PIGSTY
RPM Name: hydra_$v*
RPM Ver : 11.1-11
RPM Deps: Nil
DEB Repo: PIGSTY
DEB Name: postgresql-$v-hydra
DEB Ver : 11.1-11
DEB Deps: Nil

Details

3 - pg_analytics

Postgres for analytics, powered by DuckDB

Overview

PIGSTY 3rd Party Extension: pg_analytics : Postgres for analytics, powered by DuckDB

Information

ID: 1520
Name: pg_analytics
Alias: pg_analytics
Category: OLAP
Website: https://github.com/paradedb/pg_analytics
License: AGPLv3 License
Language: Rust
Tags: pgrx
Comment: 无

Metadata

Version: 0.2.1
PG Vers: 17,16,15,14
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Relocatable
Trusted: Trusted, Can be created by user with CREATE Privilege
Schemas: paradedb
Requires: N/A

Packages

RPM Repo: PIGSTY
RPM Name: pg_analytics_$v
RPM Ver : 0.2.1
RPM Deps: Nil
DEB Repo: PIGSTY
DEB Name: postgresql-$v-pg-analytics
DEB Ver : 0.2.1
DEB Deps: Nil

Details

4 - pg_lakehouse

pg_lakehouse: An analytical query engine for Postgres

Overview

PIGSTY 3rd Party Extension: pg_lakehouse : pg_lakehouse: An analytical query engine for Postgres

Information

ID: 1521
Name: pg_lakehouse
Alias: pg_lakehouse
Category: OLAP
Website: https://github.com/paradedb/paradedb/tree/dev/pg_lakehouse
License: AGPLv3 License
Language: Rust
Tags: pgrx
Comment:

Metadata

Version: 0.9.0
PG Vers: 16,15,14
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Relocatable
Trusted: Trusted, Can be created by user with CREATE Privilege
Schemas: paradedb
Requires: N/A

Packages

RPM Repo: PIGSTY
RPM Name: pg_lakehouse_$v
RPM Ver : 0.9.0
RPM Deps: Nil
DEB Repo: PIGSTY
DEB Name: postgresql-$v-pg-lakehouse
DEB Ver : 0.9.0
DEB Deps: Nil

Details

5 - pg_duckdb

DuckDB Embedded in Postgres

Overview

PIGSTY 3rd Party Extension: pg_duckdb : DuckDB Embedded in Postgres

Information

ID: 1530
Name: pg_duckdb
Alias: pg_duckdb
Category: OLAP
Website: https://github.com/duckdb/pg_duckdb
License: MIT License
Language: C++
Tags: N/A
Comment: 无

Metadata

Version: 0.0.1
PG Vers: 17,16,15
Need Load: Explicit Loading Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Relocatable
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PIGSTY
RPM Name: pg_duckdb_$v*
RPM Ver : 0.1.0
RPM Deps: Nil
DEB Repo: PIGSTY
DEB Name: postgresql-$v-pg-duckdb
DEB Ver : 0.1.0
DEB Deps: Nil

Details

6 - duckdb_fdw

DuckDB Foreign Data Wrapper

Overview

PIGSTY 3rd Party Extension: duckdb_fdw : DuckDB Foreign Data Wrapper

Information

ID: 1540
Name: duckdb_fdw
Alias: duckdb_fdw
Category: OLAP
Website: https://github.com/alitrack/duckdb_fdw
License: MIT License
Language: Unknown
Tags: N/A
Comment: 无

Metadata

Version: 1.0.0
PG Vers: 16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Not Relocatable
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PIGSTY
RPM Name: duckdb_fdw_$v*
RPM Ver : 1.0.0
RPM Deps: Nil
DEB Repo: PIGSTY
DEB Name: postgresql-$v-duckdb-fdw
DEB Ver : 1.0.0
DEB Deps: Nil

Details

7 - pg_parquet

copy data between Postgres and Parquet

Overview

PIGSTY 3rd Party Extension: pg_parquet : copy data between Postgres and Parquet

Information

ID: 1550
Name: pg_parquet
Alias: pg_parquet
Category: OLAP
Website: https://github.com/CrunchyData/pg_parquet/
License: PostgreSQL License
Language: Rust
Tags: pgrx
Comment: 无

Metadata

Version: 0.1.0
PG Vers: 17,16
Need Load: Explicit Loading Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Relocatable
Trusted: Trusted, Can be created by user with CREATE Privilege
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PIGSTY
RPM Name: pg_parquet_$v
RPM Ver : 0.1.0
RPM Deps: Nil
DEB Repo: PIGSTY
DEB Name: postgresql-$v-pg-parquet
DEB Ver : 0.1.0
DEB Deps: Nil

Details

8 - pg_fkpart

Table partitioning by foreign key utility

Overview

PGDG 3rd Party Extension: pg_fkpart : Table partitioning by foreign key utility

Information

ID: 1600
Name: pg_fkpart
Alias: pg_fkpart
Category: OLAP
Website: https://github.com/lemoineat/pg_fkpart
License: GPLv2 License
Language: Unknown
Tags: N/A
Comment: 无

Metadata

Version: 1.7
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Relocatable
Trusted: Untrusted, Require Superuser to Create
Schemas: pgfkpart
Requires: N/A

Packages

RPM Repo: PGDG
RPM Name: pg_fkpart_$v*
RPM Ver : 1.7
RPM Deps: Nil
DEB Repo: PIGSTY
DEB Name: postgresql-$v-pg-fkpart
DEB Ver : 1.7
DEB Deps: Nil

Details

9 - pg_partman

Extension to manage partitioned tables by time or ID

Overview

PGDG 1st Party Extension: pg_partman : Extension to manage partitioned tables by time or ID

Information

ID: 1610
Name: pg_partman
Alias: pg_partman
Category: OLAP
Website: https://github.com/pgpartman/pg_partman
License: PostgreSQL License
Language: Unknown
Tags: N/A
Comment: 无

Metadata

Version: 5.1.0
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Relocatable
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PGDG
RPM Name: pg_partman_$v*
RPM Ver : 5.1.0
RPM Deps: Nil
DEB Repo: PGDG
DEB Name: postgresql-$v-partman
DEB Ver : 5.1.0
DEB Deps: Nil

Details

10 - plproxy

Database partitioning implemented as procedural language

Overview

PGDG 1st Party Extension: plproxy : Database partitioning implemented as procedural language

Information

ID: 1620
Name: plproxy
Alias: plproxy
Category: OLAP
Website: https://github.com/plproxy/plproxy
License: BSD 0 License
Language: Unknown
Tags: N/A
Comment: 无

Metadata

Version: 2.11.0
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Relocatable
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PGDG
RPM Name: plproxy_$v*
RPM Ver : 2.11.0
RPM Deps: Nil
DEB Repo: PGDG
DEB Name: postgresql-$v-plproxy
DEB Ver : 2.11.0
DEB Deps: Nil

Details

11 - pg_strom

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

Overview

PGDG 1st Party Extension: pg_strom : PG-Strom - big-data processing acceleration using GPU and NVME

Information

ID: 1630
Name: pg_strom
Alias: pg_strom
Category: OLAP
Website: https://github.com/heterodb/pg-strom
License: PostgreSQL License
Language: Unknown
Tags: non-free
Comment: 无

Metadata

Version: 5.1
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Unknown
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PGDG
RPM Name: pg_strom_$v*
RPM Ver : 5.1
RPM Deps: Nil
DEB Repo: N/A
DEB Name: N/A
DEB Ver : N/A
DEB Deps: Nil

Details

12 - tablefunc

functions that manipulate whole tables, including crosstab

Overview

CONTRIB Built-in Extension: tablefunc : functions that manipulate whole tables, including crosstab

Information

ID: 1690
Name: tablefunc
Alias: tablefunc
Category: OLAP
Website: https://www.postgresql.org/docs/current/tablefunc.html
License: PostgreSQL License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 1.0
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Unknown
Trusted: Trusted, Can be created by user with CREATE Privilege
Schemas: N/A
Requires: N/A

Packages

PostgreSQL Built-in Contrib Extension