pg_duckdb

在PostgreSQL中的嵌入式DuckDB扩展

概览

扩展包名	版本	分类	许可证	语言
`pg_duckdb`	`1.1.1`	OLAP	MIT	C++

ID	扩展名	Bin	Lib	Load	Create	Trust	Reloc	模式
2430	`pg_duckdb`	否	是	是	是	否	否	`public`

相关扩展	`pg_mooncake` `pg_ducklake` `duckdb_fdw` `pg_parquet` `pg_lake` `pg_clickhouse` `aws_s3` `file_fdw` `pg_bulkload` `columnar`
下游依赖	`pg_mooncake`

conflict with duckdb_fdw

版本

类型	仓库	版本	PG 大版本	包名	依赖
EXT	PIGSTY	`1.1.1`	1817161514	`pg_duckdb`	-
RPM	PIGSTY	`1.1.1`	1817161514	`pg_duckdb_$v`	-
DEB	PIGSTY	`1.1.1`	1817161514	`postgresql-$v-pg-duckdb`	-

OS / PG	PG18	PG17	PG16	PG15	PG14
el8.x86_64	PIGSTY 1.1.1 el8.x86_64.pg18 : pg_duckdb_18 pg_duckdb_18-1.1.1-1PIGSTY.el8.x86_64.rpm PIGSTY · 1.1.1 · 15.4MiB	PIGSTY 1.1.1 el8.x86_64.pg17 : pg_duckdb_17 pg_duckdb_17-1.1.1-1PIGSTY.el8.x86_64.rpm PIGSTY · 1.1.1 · 15.4MiB	PIGSTY 1.1.1 el8.x86_64.pg16 : pg_duckdb_16 pg_duckdb_16-1.1.1-1PIGSTY.el8.x86_64.rpm PIGSTY · 1.1.1 · 15.4MiB	PIGSTY 1.1.1 el8.x86_64.pg15 : pg_duckdb_15 pg_duckdb_15-1.1.1-1PIGSTY.el8.x86_64.rpm PIGSTY · 1.1.1 · 15.4MiB	PIGSTY 1.1.1 el8.x86_64.pg14 : pg_duckdb_14 pg_duckdb_14-1.1.1-1PIGSTY.el8.x86_64.rpm PIGSTY · 1.1.1 · 15.4MiB
el8.aarch64	PIGSTY 1.1.1 el8.aarch64.pg18 : pg_duckdb_18 pg_duckdb_18-1.1.1-1PIGSTY.el8.aarch64.rpm PIGSTY · 1.1.1 · 13.3MiB	PIGSTY 1.1.1 el8.aarch64.pg17 : pg_duckdb_17 pg_duckdb_17-1.1.1-1PIGSTY.el8.aarch64.rpm PIGSTY · 1.1.1 · 13.3MiB	PIGSTY 1.1.1 el8.aarch64.pg16 : pg_duckdb_16 pg_duckdb_16-1.1.1-1PIGSTY.el8.aarch64.rpm PIGSTY · 1.1.1 · 13.3MiB	PIGSTY 1.1.1 el8.aarch64.pg15 : pg_duckdb_15 pg_duckdb_15-1.1.1-1PIGSTY.el8.aarch64.rpm PIGSTY · 1.1.1 · 13.3MiB	PIGSTY 1.1.1 el8.aarch64.pg14 : pg_duckdb_14 pg_duckdb_14-1.1.1-1PIGSTY.el8.aarch64.rpm PIGSTY · 1.1.1 · 13.3MiB
el9.x86_64	PIGSTY 1.1.1 el9.x86_64.pg18 : pg_duckdb_18 pg_duckdb_18-1.1.1-1PIGSTY.el9.x86_64.rpm PIGSTY · 1.1.1 · 15.8MiB	PIGSTY 1.1.1 el9.x86_64.pg17 : pg_duckdb_17 pg_duckdb_17-1.1.1-1PIGSTY.el9.x86_64.rpm PIGSTY · 1.1.1 · 15.8MiB	PIGSTY 1.1.1 el9.x86_64.pg16 : pg_duckdb_16 pg_duckdb_16-1.1.1-1PIGSTY.el9.x86_64.rpm PIGSTY · 1.1.1 · 15.8MiB	PIGSTY 1.1.1 el9.x86_64.pg15 : pg_duckdb_15 pg_duckdb_15-1.1.1-1PIGSTY.el9.x86_64.rpm PIGSTY · 1.1.1 · 15.8MiB	PIGSTY 1.1.1 el9.x86_64.pg14 : pg_duckdb_14 pg_duckdb_14-1.1.1-1PIGSTY.el9.x86_64.rpm PIGSTY · 1.1.1 · 15.8MiB
el9.aarch64	PIGSTY 1.1.1 el9.aarch64.pg18 : pg_duckdb_18 pg_duckdb_18-1.1.1-1PIGSTY.el9.aarch64.rpm PIGSTY · 1.1.1 · 14.2MiB	PIGSTY 1.1.1 el9.aarch64.pg17 : pg_duckdb_17 pg_duckdb_17-1.1.1-1PIGSTY.el9.aarch64.rpm PIGSTY · 1.1.1 · 14.2MiB	PIGSTY 1.1.1 el9.aarch64.pg16 : pg_duckdb_16 pg_duckdb_16-1.1.1-1PIGSTY.el9.aarch64.rpm PIGSTY · 1.1.1 · 14.2MiB	PIGSTY 1.1.1 el9.aarch64.pg15 : pg_duckdb_15 pg_duckdb_15-1.1.1-1PIGSTY.el9.aarch64.rpm PIGSTY · 1.1.1 · 14.2MiB	PIGSTY 1.1.1 el9.aarch64.pg14 : pg_duckdb_14 pg_duckdb_14-1.1.1-1PIGSTY.el9.aarch64.rpm PIGSTY · 1.1.1 · 14.2MiB
el10.x86_64	PIGSTY 1.1.1 el10.x86_64.pg18 : pg_duckdb_18 pg_duckdb_18-1.1.1-1PIGSTY.el10.x86_64.rpm PIGSTY · 1.1.1 · 15.1MiB	PIGSTY 1.1.1 el10.x86_64.pg17 : pg_duckdb_17 pg_duckdb_17-1.1.1-1PIGSTY.el10.x86_64.rpm PIGSTY · 1.1.1 · 15.1MiB	PIGSTY 1.1.1 el10.x86_64.pg16 : pg_duckdb_16 pg_duckdb_16-1.1.1-1PIGSTY.el10.x86_64.rpm PIGSTY · 1.1.1 · 15.1MiB	PIGSTY 1.1.1 el10.x86_64.pg15 : pg_duckdb_15 pg_duckdb_15-1.1.1-1PIGSTY.el10.x86_64.rpm PIGSTY · 1.1.1 · 15.1MiB	PIGSTY 1.1.1 el10.x86_64.pg14 : pg_duckdb_14 pg_duckdb_14-1.1.1-1PIGSTY.el10.x86_64.rpm PIGSTY · 1.1.1 · 15.1MiB
el10.aarch64	PIGSTY 1.1.1 el10.aarch64.pg18 : pg_duckdb_18 pg_duckdb_18-1.1.1-1PIGSTY.el10.aarch64.rpm PIGSTY · 1.1.1 · 13.4MiB	PIGSTY 1.1.1 el10.aarch64.pg17 : pg_duckdb_17 pg_duckdb_17-1.1.1-1PIGSTY.el10.aarch64.rpm PIGSTY · 1.1.1 · 13.4MiB	PIGSTY 1.1.1 el10.aarch64.pg16 : pg_duckdb_16 pg_duckdb_16-1.1.1-1PIGSTY.el10.aarch64.rpm PIGSTY · 1.1.1 · 13.4MiB	PIGSTY 1.1.1 el10.aarch64.pg15 : pg_duckdb_15 pg_duckdb_15-1.1.1-1PIGSTY.el10.aarch64.rpm PIGSTY · 1.1.1 · 13.5MiB	PIGSTY 1.1.1 el10.aarch64.pg14 : pg_duckdb_14 pg_duckdb_14-1.1.1-1PIGSTY.el10.aarch64.rpm PIGSTY · 1.1.1 · 13.5MiB
d12.x86_64	PIGSTY 1.1.1 d12.x86_64.pg18 : postgresql-18-pg-duckdb postgresql-18-pg-duckdb_1.1.1-1PIGSTY~bookworm_amd64.deb PIGSTY · 1.1.1 · 13.9MiB	PIGSTY 1.1.1 d12.x86_64.pg17 : postgresql-17-pg-duckdb postgresql-17-pg-duckdb_1.1.1-1PIGSTY~bookworm_amd64.deb PIGSTY · 1.1.1 · 13.9MiB	PIGSTY 1.1.1 d12.x86_64.pg16 : postgresql-16-pg-duckdb postgresql-16-pg-duckdb_1.1.1-1PIGSTY~bookworm_amd64.deb PIGSTY · 1.1.1 · 13.9MiB	PIGSTY 1.1.1 d12.x86_64.pg15 : postgresql-15-pg-duckdb postgresql-15-pg-duckdb_1.1.1-1PIGSTY~bookworm_amd64.deb PIGSTY · 1.1.1 · 13.9MiB	PIGSTY 1.1.1 d12.x86_64.pg14 : postgresql-14-pg-duckdb postgresql-14-pg-duckdb_1.1.1-1PIGSTY~bookworm_amd64.deb PIGSTY · 1.1.1 · 13.9MiB
d12.aarch64	PIGSTY 1.1.1 d12.aarch64.pg18 : postgresql-18-pg-duckdb postgresql-18-pg-duckdb_1.1.1-1PIGSTY~bookworm_arm64.deb PIGSTY · 1.1.1 · 12.0MiB	PIGSTY 1.1.1 d12.aarch64.pg17 : postgresql-17-pg-duckdb postgresql-17-pg-duckdb_1.1.1-1PIGSTY~bookworm_arm64.deb PIGSTY · 1.1.1 · 12.0MiB	PIGSTY 1.1.1 d12.aarch64.pg16 : postgresql-16-pg-duckdb postgresql-16-pg-duckdb_1.1.1-1PIGSTY~bookworm_arm64.deb PIGSTY · 1.1.1 · 12.0MiB	PIGSTY 1.1.1 d12.aarch64.pg15 : postgresql-15-pg-duckdb postgresql-15-pg-duckdb_1.1.1-1PIGSTY~bookworm_arm64.deb PIGSTY · 1.1.1 · 12.0MiB	PIGSTY 1.1.1 d12.aarch64.pg14 : postgresql-14-pg-duckdb postgresql-14-pg-duckdb_1.1.1-1PIGSTY~bookworm_arm64.deb PIGSTY · 1.1.1 · 12.0MiB
d13.x86_64	PIGSTY 1.1.1 d13.x86_64.pg18 : postgresql-18-pg-duckdb postgresql-18-pg-duckdb_1.1.1-1PIGSTY~trixie_amd64.deb PIGSTY · 1.1.1 · 14.3MiB	PIGSTY 1.1.1 d13.x86_64.pg17 : postgresql-17-pg-duckdb postgresql-17-pg-duckdb_1.1.1-1PIGSTY~trixie_amd64.deb PIGSTY · 1.1.1 · 14.3MiB	PIGSTY 1.1.1 d13.x86_64.pg16 : postgresql-16-pg-duckdb postgresql-16-pg-duckdb_1.1.1-1PIGSTY~trixie_amd64.deb PIGSTY · 1.1.1 · 14.3MiB	PIGSTY 1.1.1 d13.x86_64.pg15 : postgresql-15-pg-duckdb postgresql-15-pg-duckdb_1.1.1-1PIGSTY~trixie_amd64.deb PIGSTY · 1.1.1 · 14.3MiB	PIGSTY 1.1.1 d13.x86_64.pg14 : postgresql-14-pg-duckdb postgresql-14-pg-duckdb_1.1.1-1PIGSTY~trixie_amd64.deb PIGSTY · 1.1.1 · 14.3MiB
d13.aarch64	PIGSTY 1.1.1 d13.aarch64.pg18 : postgresql-18-pg-duckdb postgresql-18-pg-duckdb_1.1.1-1PIGSTY~trixie_arm64.deb PIGSTY · 1.1.1 · 12.2MiB	PIGSTY 1.1.1 d13.aarch64.pg17 : postgresql-17-pg-duckdb postgresql-17-pg-duckdb_1.1.1-1PIGSTY~trixie_arm64.deb PIGSTY · 1.1.1 · 12.2MiB	PIGSTY 1.1.1 d13.aarch64.pg16 : postgresql-16-pg-duckdb postgresql-16-pg-duckdb_1.1.1-1PIGSTY~trixie_arm64.deb PIGSTY · 1.1.1 · 12.2MiB	PIGSTY 1.1.1 d13.aarch64.pg15 : postgresql-15-pg-duckdb postgresql-15-pg-duckdb_1.1.1-1PIGSTY~trixie_arm64.deb PIGSTY · 1.1.1 · 12.2MiB	PIGSTY 1.1.1 d13.aarch64.pg14 : postgresql-14-pg-duckdb postgresql-14-pg-duckdb_1.1.1-1PIGSTY~trixie_arm64.deb PIGSTY · 1.1.1 · 12.2MiB
u22.x86_64	PIGSTY 1.1.1 u22.x86_64.pg18 : postgresql-18-pg-duckdb postgresql-18-pg-duckdb_1.1.1-1PIGSTY~jammy_amd64.deb PIGSTY · 1.1.1 · 15.6MiB	PIGSTY 1.1.1 u22.x86_64.pg17 : postgresql-17-pg-duckdb postgresql-17-pg-duckdb_1.1.1-1PIGSTY~jammy_amd64.deb PIGSTY · 1.1.1 · 16.0MiB	PIGSTY 1.1.1 u22.x86_64.pg16 : postgresql-16-pg-duckdb postgresql-16-pg-duckdb_1.1.1-1PIGSTY~jammy_amd64.deb PIGSTY · 1.1.1 · 16.0MiB	PIGSTY 1.1.1 u22.x86_64.pg15 : postgresql-15-pg-duckdb postgresql-15-pg-duckdb_1.1.1-1PIGSTY~jammy_amd64.deb PIGSTY · 1.1.1 · 16.0MiB	PIGSTY 1.1.1 u22.x86_64.pg14 : postgresql-14-pg-duckdb postgresql-14-pg-duckdb_1.1.1-1PIGSTY~jammy_amd64.deb PIGSTY · 1.1.1 · 16.0MiB
u22.aarch64	PIGSTY 1.1.1 u22.aarch64.pg18 : postgresql-18-pg-duckdb postgresql-18-pg-duckdb_1.1.1-1PIGSTY~jammy_arm64.deb PIGSTY · 1.1.1 · 14.2MiB	PIGSTY 1.1.1 u22.aarch64.pg17 : postgresql-17-pg-duckdb postgresql-17-pg-duckdb_1.1.1-1PIGSTY~jammy_arm64.deb PIGSTY · 1.1.1 · 14.6MiB	PIGSTY 1.1.1 u22.aarch64.pg16 : postgresql-16-pg-duckdb postgresql-16-pg-duckdb_1.1.1-1PIGSTY~jammy_arm64.deb PIGSTY · 1.1.1 · 14.6MiB	PIGSTY 1.1.1 u22.aarch64.pg15 : postgresql-15-pg-duckdb postgresql-15-pg-duckdb_1.1.1-1PIGSTY~jammy_arm64.deb PIGSTY · 1.1.1 · 14.6MiB	PIGSTY 1.1.1 u22.aarch64.pg14 : postgresql-14-pg-duckdb postgresql-14-pg-duckdb_1.1.1-1PIGSTY~jammy_arm64.deb PIGSTY · 1.1.1 · 14.6MiB
u24.x86_64	PIGSTY 1.1.1 u24.x86_64.pg18 : postgresql-18-pg-duckdb postgresql-18-pg-duckdb_1.1.1-1PIGSTY~noble_amd64.deb PIGSTY · 1.1.1 · 15.8MiB	PIGSTY 1.1.1 u24.x86_64.pg17 : postgresql-17-pg-duckdb postgresql-17-pg-duckdb_1.1.1-1PIGSTY~noble_amd64.deb PIGSTY · 1.1.1 · 15.9MiB	PIGSTY 1.1.1 u24.x86_64.pg16 : postgresql-16-pg-duckdb postgresql-16-pg-duckdb_1.1.1-1PIGSTY~noble_amd64.deb PIGSTY · 1.1.1 · 15.8MiB	PIGSTY 1.1.1 u24.x86_64.pg15 : postgresql-15-pg-duckdb postgresql-15-pg-duckdb_1.1.1-1PIGSTY~noble_amd64.deb PIGSTY · 1.1.1 · 15.8MiB	PIGSTY 1.1.1 u24.x86_64.pg14 : postgresql-14-pg-duckdb postgresql-14-pg-duckdb_1.1.1-1PIGSTY~noble_amd64.deb PIGSTY · 1.1.1 · 15.9MiB
u24.aarch64	PIGSTY 1.1.1 u24.aarch64.pg18 : postgresql-18-pg-duckdb postgresql-18-pg-duckdb_1.1.1-1PIGSTY~noble_arm64.deb PIGSTY · 1.1.1 · 14.5MiB	PIGSTY 1.1.1 u24.aarch64.pg17 : postgresql-17-pg-duckdb postgresql-17-pg-duckdb_1.1.1-1PIGSTY~noble_arm64.deb PIGSTY · 1.1.1 · 14.5MiB	PIGSTY 1.1.1 u24.aarch64.pg16 : postgresql-16-pg-duckdb postgresql-16-pg-duckdb_1.1.1-1PIGSTY~noble_arm64.deb PIGSTY · 1.1.1 · 14.5MiB	PIGSTY 1.1.1 u24.aarch64.pg15 : postgresql-15-pg-duckdb postgresql-15-pg-duckdb_1.1.1-1PIGSTY~noble_arm64.deb PIGSTY · 1.1.1 · 14.5MiB	PIGSTY 1.1.1 u24.aarch64.pg14 : postgresql-14-pg-duckdb postgresql-14-pg-duckdb_1.1.1-1PIGSTY~noble_arm64.deb PIGSTY · 1.1.1 · 14.5MiB
u26.x86_64	PIGSTY 1.1.1 u26.x86_64.pg18 : postgresql-18-pg-duckdb postgresql-18-pg-duckdb_1.1.1-1PIGSTY~resolute_amd64.deb PIGSTY · 1.1.1 · 16.3MiB	PIGSTY 1.1.1 u26.x86_64.pg17 : postgresql-17-pg-duckdb postgresql-17-pg-duckdb_1.1.1-1PIGSTY~resolute_amd64.deb PIGSTY · 1.1.1 · 16.3MiB	PIGSTY 1.1.1 u26.x86_64.pg16 : postgresql-16-pg-duckdb postgresql-16-pg-duckdb_1.1.1-1PIGSTY~resolute_amd64.deb PIGSTY · 1.1.1 · 16.3MiB	PIGSTY 1.1.1 u26.x86_64.pg15 : postgresql-15-pg-duckdb postgresql-15-pg-duckdb_1.1.1-1PIGSTY~resolute_amd64.deb PIGSTY · 1.1.1 · 16.3MiB	PIGSTY 1.1.1 u26.x86_64.pg14 : postgresql-14-pg-duckdb postgresql-14-pg-duckdb_1.1.1-1PIGSTY~resolute_amd64.deb PIGSTY · 1.1.1 · 16.3MiB
u26.aarch64	PIGSTY 1.1.1 u26.aarch64.pg18 : postgresql-18-pg-duckdb postgresql-18-pg-duckdb_1.1.1-1PIGSTY~resolute_arm64.deb PIGSTY · 1.1.1 · 15.2MiB	PIGSTY 1.1.1 u26.aarch64.pg17 : postgresql-17-pg-duckdb postgresql-17-pg-duckdb_1.1.1-1PIGSTY~resolute_arm64.deb PIGSTY · 1.1.1 · 15.2MiB	PIGSTY 1.1.1 u26.aarch64.pg16 : postgresql-16-pg-duckdb postgresql-16-pg-duckdb_1.1.1-1PIGSTY~resolute_arm64.deb PIGSTY · 1.1.1 · 15.1MiB	PIGSTY 1.1.1 u26.aarch64.pg15 : postgresql-15-pg-duckdb postgresql-15-pg-duckdb_1.1.1-1PIGSTY~resolute_arm64.deb PIGSTY · 1.1.1 · 15.2MiB	PIGSTY 1.1.1 u26.aarch64.pg14 : postgresql-14-pg-duckdb postgresql-14-pg-duckdb_1.1.1-1PIGSTY~resolute_arm64.deb PIGSTY · 1.1.1 · 15.2MiB

构建

您可以使用 pig build 命令构建 pg_duckdb 扩展的 RPM / DEB 包：

BASH

pig build pkg pg_duckdb         # 构建 RPM / DEB 包

安装

您可以直接安装 pg_duckdb 扩展包的预置二进制包，首先确保 PGDG 和 PIGSTY 仓库已经添加并启用：

BASH

pig repo add pgsql -u          # 添加仓库并更新缓存

使用 pig 或者是 apt/yum/dnf 安装扩展：

安装

BASH

pig install pg_duckdb;          # 当前活跃 PG 版本安装

pig

BASH

pig ext install -y pg_duckdb -v 18  # PG 18
pig ext install -y pg_duckdb -v 17  # PG 17
pig ext install -y pg_duckdb -v 16  # PG 16
pig ext install -y pg_duckdb -v 15  # PG 15
pig ext install -y pg_duckdb -v 14  # PG 14

dnf

BASH

dnf install -y pg_duckdb_18       # PG 18
dnf install -y pg_duckdb_17       # PG 17
dnf install -y pg_duckdb_16       # PG 16
dnf install -y pg_duckdb_15       # PG 15
dnf install -y pg_duckdb_14       # PG 14

apt

BASH

apt install -y postgresql-18-pg-duckdb   # PG 18
apt install -y postgresql-17-pg-duckdb   # PG 17
apt install -y postgresql-16-pg-duckdb   # PG 16
apt install -y postgresql-15-pg-duckdb   # PG 15
apt install -y postgresql-14-pg-duckdb   # PG 14

预加载配置：

BASH

shared_preload_libraries = 'pg_duckdb';

创建扩展：

SQL

CREATE EXTENSION pg_duckdb;

用法

pg_duckdb 文档

主题	说明
函数	所有可用函数的完整参考
语法指南与注意事项	常见 SQL 模式与注意事项速查
类型	支持的数据类型与类型映射
扩展	DuckDB 扩展的安装与使用
配置	配置选项与参数
事务	事务行为与限制

快速上手

使用 pig 安装 pg_duckdb：

BASH

pig repo set
pig install pg_duckdb

编辑 postgresql.conf，然后重启使配置生效

INI

shared_preload_libraries = 'pg_duckdb'
duckdb.allow_community_extensions = true

加速查询

通过 DuckDB 可以直接查询现有的 PostgreSQL 表，无需做任何修改：

SQL

-- pgbench -is 1000  # 使用 pgbench 初始化一些测试数据
CREATE EXTENSION pg_duckdb;

-- 默认行为，使用 PostgreSQL 原生引擎
SET duckdb.force_execution = false;
EXPLAIN ANALYZE SELECT count(*) FROM pgbench_accounts;

-- 现在查询将由 pg_duckdb 执行
SET duckdb.force_execution = true;
EXPLAIN ANALYZE SELECT count(*) FROM pgbench_accounts;

在本地笔记本电脑的 4 核虚拟机上，查询耗时从 8 秒降至 4 秒：

postgres@el9:5432/postgres=# SET duckdb.force_execution = true;
EXPLAIN ANALYZE SELECT count(*) FROM pgbench_accounts;
SET
Time: 0.206 ms
                                              QUERY PLAN
------------------------------------------------------------------------------------------------------
 Custom Scan (DuckDBScan)  (cost=0.00..0.00 rows=0 width=0) (actual time=0.001..0.001 rows=0 loops=1)
   DuckDB Execution Plan:

 ┌─────────────────────────────────────┐
 │┌───────────────────────────────────┐│
 ││    Query Profiling Information    ││
 │└───────────────────────────────────┘│
 └─────────────────────────────────────┘
 EXPLAIN ANALYZE  SELECT count(*) AS count FROM pgduckdb.public.pgbench_accounts
 ┌────────────────────────────────────────────────┐
 │┌──────────────────────────────────────────────┐│
 ││               Total Time: 3.89s              ││
 │└──────────────────────────────────────────────┘│
 └────────────────────────────────────────────────┘
 ┌───────────────────────────┐
 │           QUERY           │
 └─────────────┬─────────────┘
 ┌─────────────┴─────────────┐
 │      EXPLAIN_ANALYZE      │
 │    ────────────────────   │
 │           0 rows          │
 │          (0.00s)          │
 └─────────────┬─────────────┘
 ┌─────────────┴─────────────┐
 │    UNGROUPED_AGGREGATE    │
 │    ────────────────────   │
 │        Aggregates:        │
 │        count_star()       │
 │                           │
 │           1 row           │
 │          (0.00s)          │
 └─────────────┬─────────────┘
 ┌─────────────┴─────────────┐
 │         TABLE_SCAN        │
 │    ────────────────────   │
 │           Table:          │
 │      pgbench_accounts     │
 │                           │
 │      100,000,000 rows     │
 │          (3.88s)          │
 └───────────────────────────┘

数据湖

以下示例演示如何使用本地 MinIO 实例操作数据湖：

SQL

SELECT duckdb.create_simple_secret(
    type := 'S3', key_id := 's3user_data', secret := 'S3User.Data',
    endpoint := 'https://sss.pigsty:9000', url_style := 'path'
);

意见反馈

这个页面对您有帮助吗？

感谢反馈！请告诉我们如何改进。

抱歉给您带来不便。请告诉我们如何改进。