Postgres Conference China 2016 中国用户大会 Postgres Conference China 2016 中国用户大会 Greenplum 5.0 and Roadmap Brian Lu Pivotal 2016Postgres中国用户大会 Postgres Conference China 2016 中国用户大会 Safe Harbor • “Any Pivotal has no obligation to update forward looking information in this presentation.” 2016Postgres中国用户大会 Postgres Conference China 2016 中国用户大会 Greenplum is Growing Steady • Greenplum is Growing Steady github repo of Greenplum in 2016 – Major Greenplum 5.0 release planned early 2017 2016Postgres中国用户大会 Postgres Conference China 2016 中国用户大会 Greenplum Database Overview • Massively Parallel Processing

own the server process. [root@tar1 ~]# su - postgres -bash-4.1$ /usr/pgsql-11/bin/pg_ctl status pg_ctl: server is running (PID: 3642) /usr/pgsql-11/bin/postgres "-D" "/var/lib/pgsql/11/data" 2018年PostgreSQL中国技术大会 drwx------ 5 postgres postgres 4096 Dec 8 11:16 base -rw------- 1 postgres postgres 30 Dec 8 11:16 current_logfiles drwx------ 2 postgres postgres 4096 Dec 8 11:16 global drwx------ 2 postgres postgres postgres 4096 Dec 8 11:16 log -bash-4.1$ cd log -bash-4.1$ ll total 4 -rw------- 1 postgres postgres 186 Dec 8 11:16 postgresql- Sat.log -bash-4.1$ tail -500 postgresql-Sat.log 2018-12-08 11:16:27.017

Greenplum上云与优化 — ApsaraDB for Greenplum介绍 2016Postgres中国用户大会 目 录 content ApsaraDB for GP的定位 ApsaraDB for GP的内核优化 未来的规划 2016Postgres中国用户大会 ApsaraDB for GP的定位 2016Postgres中国用户大会 ApsaraDB for GP的定位 GP的优势？ GP的优势？ 与其他技术的对比？ 为什么上云？ 2016Postgres中国用户大会 ApsaraDB for GP的定位 ApsaraDB for GP = 简单、高效解决大数据分析需求 MPP + 列存压缩 复杂SQL + 查询优化器 本地高效存储 +高速网络 +预置稳定资源 = = 2016Postgres中国用户大会 GP vs. RDS? Select count(*) Scan Hash MPP处理举例 2016Postgres中国用户大会 GP vs. RDS? Select count(*) from customer group by city Hash Scan 主机 Hash Scan Hash Scan 主机 Hash Scan MPP处理举例 2016Postgres中国用户大会 GP vs. RDS? Select

211 Release 6.17.6 211 Resolved Issue 211 Server 211 Release 6.17.5 212 Resolved Issue 212 Postgres Query Planner 212 Release 6.17.4 212 Resolved Issues 212 Query Optimizer 212 Server 212 Release Issues 215 Postgres Planner 215 Query Optimizer 215 Server 215 Release 6.17.0 215 Features 215 Resolved Issues 216 Server 216 Query Optimizer 216 Cluster Management 217 Postgres Query Planner Registering the Module 1851 Configuring FIPS Encryption 1851 Additional Module Documentation 1853 postgres_fdw 1853 Installing and Registering the Module 1853 Greenplum Database Limitations 1853 Additional

VMware Greenplum 6 Documentation VMware, Inc. 8 Server 198 Release 6.17.5 198 Resolved Issue 198 Postgres Query Planner 198 Release 6.17.4 199 Resolved Issues 199 Query Optimizer 199 Server 199 Release Issues 201 Postgres Planner 201 Query Optimizer 202 Server 202 Release 6.17.0 202 Features 202 Resolved Issues 202 Server 203 Query Optimizer 203 Cluster Management 204 Postgres Query Planner Registering the Module 1810 Configuring FIPS Encryption 1810 Additional Module Documentation 1812 postgres_fdw 1812 Installing and Registering the Module 1813 Greenplum Database Limitations 1813 Additional

179 Release 6.17.6 180 Resolved Issue 180 Server 180 Release 6.17.5 180 Resolved Issue 180 Postgres Query Planner 180 Release 6.17.4 180 Resolved Issues 180 Query Optimizer 180 Server 181 Release Issues 183 Postgres Planner 183 Query Optimizer 183 Server 184 Release 6.17.0 184 Features 184 Resolved Issues 184 Server 184 Query Optimizer 185 Cluster Management 185 Postgres Query Planner Registering the Module 1818 Configuring FIPS Encryption 1818 Additional Module Documentation 1820 postgres_fdw 1820 Installing and Registering the Module 1820 Greenplum Database Limitations 1820 Additional

172 Release 6.17.6 172 Resolved Issue 173 Server 173 Release 6.17.5 173 Resolved Issue 173 Postgres Query Planner 173 Release 6.17.4 173 Resolved Issues 173 Query Optimizer 173 Server 173 Release Issues 176 Postgres Planner 176 Query Optimizer 176 Server 176 Release 6.17.0 176 Features 177 Resolved Issues 177 Server 177 Query Optimizer 177 Cluster Management 178 Postgres Query Planner Registering the Module 1768 Configuring FIPS Encryption 1768 Additional Module Documentation 1770 postgres_fdw 1770 Installing and Registering the Module 1770 Greenplum Database Limitations 1770 Additional

169 Release 6.17.6 169 Resolved Issue 169 Server 169 Release 6.17.5 169 Resolved Issue 169 Postgres Query Planner 169 Release 6.17.4 170 Resolved Issues 170 Query Optimizer 170 Server 170 Release Issues 172 Postgres Planner 172 Query Optimizer 173 Server 173 Release 6.17.0 173 Features 173 Resolved Issues 173 Server 174 Query Optimizer 174 Cluster Management 175 Postgres Query Planner Registering the Module 1762 Configuring FIPS Encryption 1762 Additional Module Documentation 1763 postgres_fdw 1763 Installing and Registering the Module 1764 Greenplum Database Limitations 1764 Additional

154 Release 6.17.6 154 Resolved Issue 155 Server 155 Release 6.17.5 155 Resolved Issue 155 Postgres Query Planner 155 Release 6.17.4 155 Resolved Issues 155 Query Optimizer 155 VMware Tanzu Greenplum Issues 158 Postgres Planner 158 Query Optimizer 158 Server 158 Release 6.17.0 158 Features 158 Resolved Issues 158 Server 159 Query Optimizer 159 Cluster Management 160 Postgres Query Planner pgcrypto 1557 Installing and Registering the Module 1557 Additional Module Documentation 1557 postgres_fdw 1557 Installing and Registering the Module 1557 Greenplum Database Limitations 1557 Additional

163 Release 6.17.6 163 Resolved Issue 163 Server 163 Release 6.17.5 164 Resolved Issue 164 Postgres Query Planner 164 Release 6.17.4 164 Resolved Issues 164 Query Optimizer 164 Server 164 Release Extensions 165 Query Optimizer 165 Server 166 gpload 166 Release 6.17.1 166 Resolved Issues 166 Postgres Planner 166 Query Optimizer 167 Server 167 Release 6.17.0 167 Features 167 Resolved Issues 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 Analyze