Pivotal Greenplum 5： 新一代数据平台 开源、支持多种云的高级分析数据平台 作者：Keaton Adams、 Dan Baskette、 Cesar Rojas pivotal.io/cn 白皮书 2 © Copyright 2017 Pivotal Software, Inc.保留所有权利。 PIVOTAL GREENPLUM 5：新一代数据平台 目录 关于本白皮书 ..............................................................................3 Pivotal Greenplum 5：新一代数据平台 .........................................................................................3 2017 Pivotal Software, Inc.保留所有权利。 PIVOTAL GREENPLUM 5：新一代数据平台 关于本白皮书 Pivotal 最近推出全球第一个开源、支持多云的高级分析数据平台——Pivotal Greenplum 5。本白皮书着眼介绍 Greenplum 5 的核心特征，及多年来围绕该平台发展出的生态系统。 摘要 Pivotal Greenplum 不受限于

Confidential–Inter nal Use Only 1 © Copyright 2013 Pivotal. All rights reserved. Greenplum 数据库架构分析及5.x 新功能分享 杨瑜 Pivotal中国研发中心 2 Pivotal Confidential–Inter nal Use Only 日程 Ÿ Greenplum 数据库（GPDB）简介 Ÿ Greenplum 数据库（GPDB）架构 Ÿ Greenplum 数据库（GPDB）组件 Ÿ Greenplum 数据库（GPDB）执行流程 Ÿ Greenplum 数据库（GPDB）5.x 3 Pivotal Confidential–Inter nal Use Only 3 © Copyright 2013 Pivotal. All rights reserved. Greenplum 企业级数据库：全球大客户超过 1000+ 安装集群 Ÿ 百万行源代码，超过10年的全球研发投入 Ÿ 开源数据库(greenplum.org)，良性生态系统 5 Pivotal Confidential–Inter nal Use Only 5 © Copyright 2013 Pivotal. All rights reserved. Greenplum 架构 6 Pivotal Confidential–Inter

6.19.0 163 Features 163 Resolved Issues 164 VMware Tanzu Greenplum 6 Documentation VMware, Inc 5 Cluster Management 164 Data Flow 165 Greenplum Installation 165 Query Planner 165 Server 165 Release 6 Documentation VMware, Inc 18 Migrating PXF from Greenplum 5.x to 6.x 450 Prerequisites 451 Step 1: Complete PXF Greenplum Database 5.x Pre-Migration Actions 451 Step 2: Migrating PXF to Greenplum Upgrading PXF 461 Migrating Data from Greenplum 4.3 or 5 to Greenplum 6 462 Preparing the Greenplum 6 Cluster 462 Preparing Greenplum 4.3 and 5 Databases for Backup 464 About Migrating Views Created

Resolved Issues 161 Cluster Management 161 VMware Tanzu Greenplum 6 Documentation VMware, Inc. 5 Data Flow 161 Greenplum Installation 161 Query Planner 161 Server 162 Release 6.18 163 Release 447 PXF Upgrade and Migration 447 Migrating PXF from Greenplum 5.x to 6.x 448 Prerequisites 448 Step 1: Complete PXF Greenplum Database 5.x Pre-Migration Actions 449 Step 2: Migrating PXF to Greenplum Data from Greenplum 4.3 or 5 to Greenplum 6 459 VMware Tanzu Greenplum 6 Documentation VMware, Inc. 19 Preparing the Greenplum 6 Cluster 459 Preparing Greenplum 4.3 and 5 Databases for Backup 461 About

Release 6.19.4 166 Resolved Issues 166 Data Flow 166 VMware Greenplum 6 Documentation VMware, Inc 5 Server 166 Release 6.19.3 166 Resolved Issues 167 Server 167 Query Optimizer 167 Data Flow 167 466 PXF Upgrade and Migration 466 Migrating PXF from Greenplum 5.x to 6.x 466 Prerequisites 467 Step 1: Complete PXF Greenplum Database 5.x Pre-Migration Actions 467 Step 2: Migrating PXF to Greenplum Upgrading PXF 477 Migrating Data from Greenplum 4.3 or 5 to Greenplum 6 478 Preparing the Greenplum 6 Cluster 479 Preparing Greenplum 4.3 and 5 Databases for Backup 480 About Migrating Views Created

Resolved Issues 163 Server 163 Query Processing 164 VMware Greenplum 6 Documentation VMware, Inc. 5 Data Flow 165 Release 6.22.1 165 Resolved Issues 165 Server 165 Query Processing 166 Cluster Management 441 PXF Upgrade and Migration 441 Migrating PXF from Greenplum 5.x to 6.x 442 Prerequisites 442 Step 1: Complete PXF Greenplum Database 5.x Pre-Migration Actions 443 Step 2: Migrating PXF to Greenplum Upgrading PXF 453 Migrating Data from Greenplum 4.3 or 5 to Greenplum 6 453 Preparing the Greenplum 6 Cluster 454 Preparing Greenplum 4.3 and 5 Databases for Backup 456 About Migrating Views Created

Processing 166 Data Flow 166 Cluster Management 166 VMware Greenplum 6 Documentation VMware by Broadcom 5 Release 6.23 167 Release 6.23.5 167 Changed Features 167 Resolved Issues 167 Server 167 Release 460 PXF Upgrade and Migration 460 Migrating PXF from Greenplum 5.x to 6.x 461 Prerequisites 461 Step 1: Complete PXF Greenplum Database 5.x Pre-Migration Actions 462 Step 2: Migrating PXF to Greenplum Upgrading PXF 472 Migrating Data from Greenplum 4.3 or 5 to Greenplum 6 472 Preparing the Greenplum 6 Cluster 473 Preparing Greenplum 4.3 and 5 Databases for Backup 475 About Migrating Views Created

155 Resolved Issues 155 Query Optimizer 155 VMware Tanzu Greenplum 6 Documentation VMware, Inc 5 Server 155 Release 6.17.3 155 Resolved Issues 156 Query Optimizer 156 Server 156 Release 6.17 377 PXF Upgrade and Migration 377 Migrating PXF from Greenplum 5.x to 6.x 377 Prerequisites 378 Step 1: Complete PXF Greenplum Database 5.x Pre-Migration Actions 378 Step 2: Migrating PXF to Greenplum Upgrading PXF 387 Migrating Data from Greenplum 4.3 or 5 to Greenplum 6 388 Preparing the Greenplum 6 Cluster 388 Preparing Greenplum 4.3 and 5 Databases for Backup 389 About Migrating Views Created

167 Query Optimizer 168 Cluster Management 168 VMware Greenplum v6.19 Documentation VMware, Inc. 5 Postgres Query Planner 169 Release 6.16 169 Release 6.16.3 169 Resolved Issues 169 Server 169 Migrating or Upgrading to Greenplum 6 0 Preparing the Greenplum 6 Cluster 300 Preparing Greenplum 4.3 and 5 Databases for Backup and Upgrade 301 Backing Up and Restoring a Database 305 Completing the Migration Post Expansion Tasks 0 Removing the Expansion Schema 612 Setting Up PXF on the New Host 613 PXF 5 613 PXF 6 613 Migrating Data with gpcopy 613 Migrating Data with gpcopy 0 Monitoring a Greenplum

Resolved Issues 167 Release 6.14.0 167 Features 167 VMware Greenplum v6.18 Documentation VMware, Inc. 5 Resolved Issues 168 Release 6.13 169 Release 6.13.0 169 Features 169 Resolved Issues 170 Release Migrating or Upgrading to Greenplum 6 0 Preparing the Greenplum 6 Cluster 290 Preparing Greenplum 4.3 and 5 Databases for Backup and Upgrade 292 Backing Up and Restoring a Database 296 Completing the Migration Post Expansion Tasks 0 Removing the Expansion Schema 603 Setting Up PXF on the New Host 604 PXF 5 604 PXF 6 604 Migrating Data with gpcopy 604 Migrating Data with gpcopy 0 Monitoring a Greenplum