下推 到所有在 Pivotal Greenplum 服务器上运行的 PEP 代理处。 Big Date2.indd 52 16-11-22 下午3:38 Greenplum 精粹文集 53 在 PivotalGreenplum 集群上，每当用户发出一个查询使用 Protegrity 所提供的功能时，查询操作就将立即检索数据，然后该功能将联系本 地的 PEP 代理。此功能可向 PEP Protegrity ESA 服务 器。Protegrity ESA 的安装不在本文的讨论范围之内，不过你可以从 Protegrity 客户团队中轻松获取相关信息。 Big Date2.indd 53 16-11-22 下午3:38 54 在安装 ESA 之后，下一步将安装 Pivotal Greenplum 的 Protegrity 数 据库保护器，这包括在所有的 Greenplum 节点和主节点上安装

Date Customer ID 50 Oct 20 2005 34 56 Oct 20 2005 213 63 Oct 20 2005 15 44 Oct 20 2005 102 53 Oct 20 2005 82 55 Oct 20 2005 55 9 Pivotal Confidential–Inter nal Use Only Segment 1A Segment 1B

2005 32 48 Oct 20 2005 12 50 Oct 20 2005 34 56 Oct 20 2005 213 63 Oct 20 2005 15 44 Oct 20 2005 102 53 Oct 20 2005 82 55 Oct 20 2005 55 CREATE TABLE orders (id serial, … order_date timestamp) Distributed

比较二：2000 万条记录BO 报表查询 Oracle Greenplum 311秒 7156毫秒 Oracle Greenplum 7分4秒 8秒 GP比Oracle提升倍数 43倍 53倍 测试内容 测试结果 真正的市场突破 100 TB 12 kW, 2个机架 180万美元 20 TB 20 kW, 8个机架 2000万美元 40 总结 • Greenplum正在将强大的并行计算能力融入到大

11 7524 31 5329 51 11046 71 5146 91 783 12 1197 32 2954 52 2760 72 14359 92 1885 13 7191 33 3796 53 3173 73 2412 93 28 14 80265 34 2654 54 5921 74 5130 94 2277 15 1744 35 4716 55 2874 75 7883 95 17445

886 WITH Queries (Common Table Expressions) 887 VMware Greenplum v6.18 Documentation VMware, Inc. 53 WITH Queries (Common Table Expressions) 0 SELECT in a WITH Clause 887 Data-Modifying Statements r_shared devel 7427f920669d 10 months ago pivotaldata/plcontainer_ python_shared devel e36827eba53e 10 months ago pivotaldata/plcontainer_ python3_shared devel y32827ebe55b 5 months ago VMware Greenplum complete 20180803:15:40:53 gpbackup:gpadmin:mdw:002907-[INFO]:-Found neither /usr/local/greenplum-db/./ bin/gp_email_contacts.yaml nor /home/gpadmin/gp_email_contacts.yaml 20180803:15:40:53 gpbackup:gpadmin

Determining the Query Optimizer that is Used 878 VMware Greenplum v6.19 Documentation VMware, Inc. 53 Determining the Query Optimizer that is Used 0 Examples 879 About Uniform Multi-level Partitioned r_shared devel 7427f920669d 10 months ago pivotaldata/plcontainer_ python_shared devel e36827eba53e 10 months ago pivotaldata/plcontainer_ python3_shared devel y32827ebe55b 5 months ago Add the image complete 20180803:15:40:53 gpbackup:gpadmin:mdw:002907-[INFO]:-Found neither /usr/local/greenplum-db/./ bin/gp_email_contacts.yaml nor /home/gpadmin/gp_email_contacts.yaml 20180803:15:40:53 gpbackup:gpadmin

Performance 0 Understanding the Performance Factors 926 VMware Greenplum v6.17 Documentation VMware, Inc. 53 System Resources 927 Workload 927 Throughput 927 Contention 927 Optimization 927 Determining r_shared devel 7427f920669d 10 months ago pivotaldata/plcontainer_ python_shared devel e36827eba53e 10 months ago pivotaldata/plcontainer_ python3_shared devel y32827ebe55b 5 months ago VMware Greenplum complete 20180803:15:40:53 gpbackup:gpadmin:mdw:002907-[INFO]:-Found neither /usr/local/greenplum-db/./ bin/gp_email_contacts.yaml nor /home/gpadmin/gp_email_contacts.yaml 20180803:15:40:53 gpbackup:gpadmin

1070 CREATE GROUP 1070 CREATE INDEX 1070 VMware Tanzu Greenplum v6.20 Documentation VMware, Inc. 53 CREATE LANGUAGE 1071 CREATE MATERIALIZED VIEW 1071 CREATE OPERATOR 1071 CREATE OPERATOR CLASS 1071 er_r_shared devel 7427f920669d 10 months ago pivotaldata/plcontainer_python_shared devel e36827eba53e 10 months ago pivotaldata/plcontainer_python3_shared devel y32827ebe55b 5 months ago Add the image complete 20180803:15:40:53 gpbackup:gpadmin:mdw:002907-[INFO]:-Found neither /usr/local/greenplum-db/./ bin/gp_email_contacts.yaml nor /home/gpadmin/gp_email_contacts.yaml 20180803:15:40:53 gpbackup:gpadmin

Data Model 1212 Heap vs. Append-Optimized Storage 1212 VMware Greenplum 6 Documentation VMware, Inc 53 Row vs. Column Oriented Storage 1212 Compression 1213 Distributions 1213 Resource Queue Memory information about this topology on page 109 of the Dell EMC VxRail Network Planning Guide (Figure 53). Configure the port groups in your VMware vSphere environment: 1. On the VMware vSphere Client 6I4iAX/NekqSyF+OgBfC9aCgS5RG8hYoOCbp8na5R3bgiuS8IzmVmm5OhZ4MDEwg nQP7BzmR0p5BahpZ8r3Ada7FcK+0ZLLRdLmOYF/yUrZ53SoYCZRzU/GmtQ7LkXBh Different keys may have the same ID. This is rare, but is a normal event. The