pgconf-china-2024-冯若航（最新版）.pdf

1、PIGSTYand duckdb_fdwAutoTuneAdminSOPLOCAL REPOYUM/APTIaaS ProvisioningLocal SandboxPlaybook as IaC ControllerWeb PortalPG BouncerPoolingService Acces&Load BalancingDNSMASQName ResolvingNode L2 VIP BindingVIPManagerPGSQL Primary L2 VIPMonnitoringRetemo RDSMonnitoringOther DBMSVisualizationMetrics TSD

2、BpgBackRestPATRONIDCS for HAConsensusbackup repoOPTIONALHAPITRCAself-signedACLPGVECTORPostgresMLHYDRAzhparserPostgresInfrastructuresGraphicsServiceToolboxComposabilityYoursAvailbilityMaintainability Observability ExtensibilityReliability 冯若航/Vonng 开源 RDS PG-Pigsty 创始人 PostgreSQL 中文社区 开源技术委员数据库世界的未来E

3、xtensionServicePostgreSQLPigstyPigsty Founder PostgreSQL中文社区技术委员会技术委员 曾任职于 Apple，TanTan，Alibaba 译注有 DDIA，PG Internal架构师，内部创业者PostgreSQL DBA架构师，PG 专家工业互联网冯若航Apple互联网应用探探互联网平台阿里基础软件Pigsty创始人，全栈专家Github:Vonng StarRank:490PostgreSQL 专家，开源贡献者 全栈专家，架构师，DBA，KOL2015-20172017-2018 2020-202220192022+https:/ M

4、e公众号：法加冯作者 数据库司机/云计算泥流PGCon.Dev 2024 Vancouver OLAP 挑战者HYDRADuckDB FDWpg-strompg_tierS3 FDWOLAP1000 x未调优PG47x调优PG42xHydra10 xParadeDB3xDuckDB-create extensionCREATE EXTENSION duckdb_fdw;-create duckdb_fdw serverCREATE SERVER duckdb_server FOREIGN DATA WRAPPER duckdb_fdw OPTIONS(database/tmp/duck.db)

5、;-create user mapping OPTIONAL-GRANT USAGE ON FOREIGN SERVER duckdb_server TO PUBLIC;SELECT duckdb_fdw_version();-You can execute duckdb command with duckdb_execute,for example,to create a table inside duckdb:-create a table in duckdbSELECT duckdb_execute(duckdb_server,CREATE TABLE t1(a integer,b va

6、rchar););-create duckdb foreign table mapping that duckdb tableCREATE FOREIGN TABLE t1(a integer,b text)SERVER duckdb_server OPTIONS(table t1);-write some data and read it backINSERT INTO t1 SELECT i AS a,i:text AS b FROM generate_series(1,10)i;SELECT*FROM t1;PG 有 DuckDB FDW！OSS Rank:PostgreSQL Ecos