Postgres Conference China 2016 中国用户大会 Postgres Conference China 2016 中国用户大会 Greenplum 5.0 and Roadmap Brian Lu Pivotal 2016Postgres中国用户大会 Postgres Conference China 2016 中国用户大会 Safe Harbor • “Any Greenplum in 2016 – 111 unique contributors on github repo of Greenplum in 2016 – Major Greenplum 5.0 release planned early 2017 2016Postgres中国用户大会 Postgres Conference China 2016 中国用户大会 Greenplum Database Base Vision Greenplum in the long run will be based on latest PostgreSQL Upcoming Roadmap – GPDB 5.0 release upgrade from PG 8.2 to PG 8.3 (2017 time frame) – JSON/JSONB – Full Text Search – Improved

开源 MPP 数据库的不二之选: Pivotal Greenplum 5.0 姚延栋 yyao@pivotal.io 开放源代码 SQL 企业级数据库 生态系统 MPP 高速数据加载 多态存储 表‘SALES’ 列存储 行存储 1月 一年前 二年前 外部表 12月 11月 4月 CLUSTERING REGRESSION CLASSIFICATION GRAPH GEOSPATIAL STRUCTURED QUERY LANGUAGE Greenplum 5.0 • Open Source Based Database • PG 8.2 à PG 8.3 • Analyze Speed Enhancement • Asynchronous

把敏捷软件开发方法学引入到分布式数据库的开发中，通过使用站立会议、 回顾会议、结对编程、持续集成、测试驱动、单周迭代等敏捷方法建立了高效的快速反馈系统， 大大提高了产品的质量和客户的满意度。Greenplum 5.0 是开源之后发布的第一个稳定版本，大 约保持 1 个半月一个版本的发布速度。Greenplum 主干分支（master）开发非常活跃，众多社区 期待的特性稳健推进中，包括内核升级、新课题，处于业界领先地位。

Pivotal. All rights reserved. Greenplum 5.x 37 Pivotal Confidential–Inter nal Use Only Greenplum 5.0 2017年9月已经发布！ Ÿ PostgreSQL Core Features Ÿ Python 2.7 Ÿ gpdbrestore Support for CASTs Ÿ Enhanced

and to avoid difficult future upgrades. Install Greenplum Database minor releases, for example 5.0.x. Recommended frequency: quarterly Severity: IMPORTANT Follow upgrade instructions in the Greenplum Broadcom 1302 START TRANSACTION TRUNCATE UNLISTEN UPDATE VACUUM VALUES * Not implemented in 5.0 SQL Syntax Summary ABORT ALTER AGGREGATE ALTER COLLATION ALTER CONVERSION ALTER DATABASE ALTER PgBouncer enables use of additional connections from the reserve pool. 0 deactivates. Default: 5.0 max_db_connections Do not allow more than this many server connections per database (regardless of

fixes, and to avoid difficult future upgrades. Install Greenplum Database minor releases, for example 5.0.x. Recommended frequency: quarterly Severity: IMPORTANT Follow upgrade instructions in the Greenplum SET TRANSACTION SHOW START TRANSACTION TRUNCATE UPDATE VACUUM VALUES * Not implemented in 5.0 SQL Syntax Summary ABORT ALTER AGGREGATE ALTER COLLATION ALTER CONVERSION ALTER DATABASE ALTER seconds, PgBouncer enables use of additional connections from the reserve pool. 0 disables. Default: 5.0 max_db_connections Do not allow more than this many server connections per database (regardless of

Activities Activity Procedure Corrective Actions Install Greenplum Database minor releases, for example 5.0.x. Recommended frequency: quarterly Severity: IMPORTANT Follow upgrade instructions in the Greenplum VMware, Inc 1285 START TRANSACTION TRUNCATE UNLISTEN UPDATE VACUUM VALUES * Not implemented in 5.0 SQL Syntax Summary ABORT ALTER AGGREGATE ALTER COLLATION ALTER CONVERSION ALTER DATABASE ALTER PgBouncer enables use of additional connections from the reserve pool. 0 deactivates. Default: 5.0 max_db_connections Do not allow more than this many server connections per database (regardless of

fixes, and to avoid difficult future upgrades. Install Greenplum Database minor releases, for example 5.0.x. Recommended frequency: quarterly Severity: IMPORTANT Follow upgrade instructions in the Greenplum VMware, Inc 1245 START TRANSACTION TRUNCATE UNLISTEN UPDATE VACUUM VALUES * Not implemented in 5.0 SQL Syntax Summary ABORT ALTER AGGREGATE ALTER COLLATION ALTER CONVERSION ALTER DATABASE ALTER PgBouncer enables use of additional connections from the reserve pool. 0 deactivates. Default: 5.0 max_db_connections Do not allow more than this many server connections per database (regardless of

and to avoid difficult future upgrades. Install Greenplum Database minor releases, for example 5.0.x. Recommended frequency: quarterly Severity: IMPORTANT Follow upgrade instructions in the Greenplum VMware, Inc. 1240 START TRANSACTION TRUNCATE UNLISTEN UPDATE VACUUM VALUES * Not implemented in 5.0 SQL Syntax Summary ABORT ALTER AGGREGATE ALTER COLLATION ALTER CONVERSION ALTER DATABASE ALTER PgBouncer enables use of additional connections from the reserve pool. 0 deactivates. Default: 5.0 max_db_connections Do not allow more than this many server connections per database (regardless of

and to avoid difficult future upgrades. Install Greenplum Database minor releases, for example 5.0.x. Recommended frequency: quarterly Severity: IMPORTANT Follow upgrade instructions in the Greenplum VMware, Inc. 1270 START TRANSACTION TRUNCATE UNLISTEN UPDATE VACUUM VALUES * Not implemented in 5.0 SQL Syntax Summary ABORT ALTER AGGREGATE ALTER COLLATION ALTER CONVERSION ALTER DATABASE ALTER PgBouncer enables use of additional connections from the reserve pool. 0 deactivates. Default: 5.0 max_db_connections Do not allow more than this many server connections per database (regardless of