• 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 can help with availability Postgres Conference China 2016 中国用户大会 PostgreSQL 9.6 Parallel Query • New in 9.6: Parallel Query • Prior to 9.6, if you had a 32 core system, needed to run one large query

3. AnalyticDB for PostgreSQL 典型场景 4. AnalyticDB for PostgreSQL 未来演进 AnalyticDB for PostgreSQL 在线MPP数据仓库服务 简单易用、海量扩展、兼容部分Oracle 语法生态、既支持在线交互分析，也支持离线数据处理。 AnalyticDB for PostgreSQL （云Greenplum）低成本，快速 应用易开发、适配 支持SQL 2003，部分兼容Oracle语法， 支持PL/SQL 存储过程，OLAP窗口函数，事务及数据库标准隔离级别 完备功能和生态，实现应用快速迁移或适配 • PB级数据秒级响应 MPP水平扩展架构，PB级数据查询秒级响应；向量化计算，及列存储智能索引，领先传统数据库引擎性能 3x； 新一代SQL优化器，实现复杂分析语句免调优 • 支持多模分析 通过PostGIS 插件支持 地理信息数据分析；MADlib 128GB 1.28TB SSD 【大容量】计算组 CPU/核 内存 用户数据空间 2x2C HDD 4 32GB 2TB HDD 2x18C HDD 36 288GB 18TB HDD ⚫ MPP 全并行执行架构，其单计算节点定位为“计算 组”，一个集群实例由多个计算组组成。 ⚫ 多种规格、满足不同场景需求 -交互式分析 -ETL数据清洗 增强的企业级特性-安全  -数据的备份&恢复

................... 3 1.3. Creating a Database ...................................................................................... 4 1.4. Accessing a Database ...................................... ............................................................................... 111 5.13. Other Database Objects ............................................................................. 111 5.14. Planner with Explicit JOIN Clauses ....................................... 532 14.4. Populating a Database .............................................................................. 534 14.5. Non-Durable

...................... 3 1.3. Creating a Database ................................................................................. 3 1.4. Accessing a Database ........................................ ............................................................................... 105 5.13. Other Database Objects ....................................................................... 105 iii PostgreSQL the Planner with Explicit JOIN Clauses ................................. 504 14.4. Populating a Database ......................................................................... 506 14.5. Non-Durable

................... 3 1.3. Creating a Database ...................................................................................... 4 1.4. Accessing a Database ...................................... ............................................................................... 111 5.13. Other Database Objects ............................................................................. 112 5.14. Planner with Explicit JOIN Clauses ....................................... 518 14.4. Populating a Database .............................................................................. 520 14.5. Non-Durable

...................... 3 1.3. Creating a Database ................................................................................. 3 1.4. Accessing a Database ........................................ ............................................................................... 105 5.13. Other Database Objects ....................................................................... 105 iii PostgreSQL the Planner with Explicit JOIN Clauses ................................. 490 14.4. Populating a Database ......................................................................... 492 14.5. Non-Durable

................... 3 1.3. Creating a Database ...................................................................................... 4 1.4. Accessing a Database ...................................... ............................................................................... 117 5.14. Other Database Objects ............................................................................. 117 5.15. Planner with Explicit JOIN Clauses ....................................... 570 14.4. Populating a Database .............................................................................. 572 14.5. Non-Durable

...................... 3 1.3. Creating a Database ................................................................................. 3 1.4. Accessing a Database ........................................ ....................................... 110 iii PostgreSQL 17beta1 Documentation 5.14. Other Database Objects ....................................................................... 110 5.15. Dependency the Planner with Explicit JOIN Clauses ................................. 539 14.4. Populating a Database ......................................................................... 541 14.5. Non-Durable

...................... 3 1.3. Creating a Database ................................................................................. 3 1.4. Accessing a Database ........................................ ............................................................................... 106 5.13. Other Database Objects ....................................................................... 106 iii PostgreSQL the Planner with Explicit JOIN Clauses ................................. 486 14.4. Populating a Database ......................................................................... 488 14.5. Non-Durable

................... 3 1.3. Creating a Database ...................................................................................... 4 1.4. Accessing a Database ...................................... ............................................................................... 112 5.13. Other Database Objects ............................................................................. 113 5.14. Planner with Explicit JOIN Clauses ....................................... 513 14.4. Populating a Database .............................................................................. 515 14.5. Non-Durable