2010年初加入支付宝，负责Oracle RAC和Greenplum数据仓库 ⚫ 有幸参与了Oracle RAC到 Greenplum再到Hadoop以及最终到 ODPS的架构演进工作。 ⚫ 2012年起，转至阿里巴巴大数据团队，负责Hbase/OTS业务支 撑，期间多次负责阿里大数据双11架构和稳定性工作 ⚫ 2018年，在阿里云数据库负责OLAP产品管理团队。 1. Greenplum发展史 @Alibaba PostgreSQL 未来演进 Greenplum发展史@Alibaba rac1 rac2 rac3 rac n Oracle RAC 11G ODPS ETL建模 交互式分析 AnalyticDB for MySQL 实时数仓 ⚫ All In One数仓去O ⚫ 交互式分析 ⚫ 中小规模实时数仓 小烟枪在阿里的场景裂变 Greenplum发展史@Alibaba 产品云化-服务中小企业 所趋  阿里云能够提供一站式的分析解决方案  PostgreSQL的生态发展迅猛  大数据发展势头放缓  数据库更简单易用 为什么要提供Greenplum云服务 弹性 托管 高可用 安全 监控 1. Greenplum发展史 @Alibaba 2. AnalyticDB for PostgreSQL产品介绍 3. AnalyticDB for PostgreSQL 典型场景

• Engineer at Huawei (USA based) • Co-organizer of NYC PostgreSQL User Group • PostgreSQL-based database clusters • GridSQL • Postgres-XC • Postgres-XL Postgres Conference China 2016 中国用户大会 Agenda buffer • Before this, even with synchronous_commit = on, it was possible that after writing to the database and reading from a replica that the data might not yet have be applied.. • Synchronous replication applications and actual data • PL = Procedural Language • Must write two stored functions for every database access – Function on shard node for actual data access – Top level proxy function determines which

...........1 1.3. Creating a Database...........................................................................................................2 1.4. Accessing a Database ............................ Constraint Exclusion ................................................................66 5.10. Other Database Objects ....................................................................................... with Explicit JOIN Clauses...................................................240 13.4. Populating a Database ...............................................................................................

...........1 1.3. Creating a Database...........................................................................................................2 1.4. Accessing a Database ............................ Constraint Exclusion ................................................................66 5.10. Other Database Objects ....................................................................................... with Explicit JOIN Clauses...................................................239 13.4. Populating a Database ...............................................................................................

...........1 1.3. Creating a Database...........................................................................................................2 1.4. Accessing a Database ............................ .................................................................................61 5.9. Other Database Objects ....................................................................................... with Explicit JOIN Clauses...................................................222 13.4. Populating a Database ...............................................................................................

..............1 1.3. Creating a Database....................................................................................................2 1.4. Accessing a Database ................................ .................................................................................57 5.9. Other Database Objects ....................................................................................... Planner with Explicit JOIN Clauses............................................210 13.4. Populating a Database ..........................................................................................212 13

...........1 1.3. Creating a Database...........................................................................................................2 1.4. Accessing a Database ............................ ................................................................................69 5.10. Other Database Objects ....................................................................................... with Explicit JOIN Clauses...................................................252 13.4. Populating a Database ...............................................................................................

...........1 1.3. Creating a Database...........................................................................................................2 1.4. Accessing a Database ............................ ................................................................................69 5.10. Other Database Objects ....................................................................................... with Explicit JOIN Clauses...................................................252 13.4. Populating a Database ...............................................................................................

...........1 1.3. Creating a Database...........................................................................................................2 1.4. Accessing a Database ............................ .................................................................................93 5.12. Other Database Objects ....................................................................................... ....................................................................................343 9.26.7. Database Object Management Functions........................................................347 9.26.8. Index

...........1 1.3. Creating a Database...........................................................................................................2 1.4. Accessing a Database ............................ ................................................................................70 5.10. Other Database Objects ....................................................................................... with Explicit JOIN Clauses...................................................322 14.4. Populating a Database ...............................................................................................