阿里云 AnalyticDB for PostgreSQL - 打造更简单易用的Cloud SQL Data Warehouse 个人介绍 缪长风 ⚫ 2010年初加入支付宝，负责Oracle RAC和Greenplum数据仓库 ⚫ 有幸参与了Oracle RAC到 Greenplum再到Hadoop以及最终到 ODPS的架构演进工作。 ⚫ 2012年起，转至阿里巴巴大数据团队，负责Hbase/OTS业务支 RDS 关系型数据 库D ECS自建 自建大数据计算平台 Hadoop Spark EMR Dataphi n OSS海量云存储 Data Lake Store DTS 实时同步 Dump Data Dump Data 数据集成 按需回流 数据仓库应用 在线数据仓库 数据 查询 数据集成 批量同步 1 3 4 2 云化在线数仓 ： 简化、敏捷、一栈式构筑数据仓库

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 (on) may reduce write transaction throughput potentially more so • If it is acceptable to have stale reads from replicas, and it is ok to lose some data and you need more write throughput, consider synchronous_commit off. Can set per transaction. Postgres replicates everything – pglogical’s logical replication permits selective replication for subsets of data for example Postgres Conference China 2016 中国用户大会 Bidirectional Replication (BDR) • 2nd Quadrant’s

Evaluation Rules ............................................................................40 5. Data Definition....................................................................................... Value...................................................................54 5.5.6. Changing a Column’s Data Type ........................................................................54 5.5.7. Renaming a .............70 6. Data Manipulation........................................................................................................................72 6.1. Inserting Data ...................

Evaluation Rules ............................................................................40 5. Data Definition....................................................................................... Value...................................................................54 5.5.6. Changing a Column’s Data Type ........................................................................54 5.5.7. Renaming a .............70 6. Data Manipulation........................................................................................................................72 6.1. Inserting Data ...................

Mixed Notation..................................................................................48 5. Data Definition....................................................................................... Default Value............................................................63 5.5.6. Changing a Column’s Data Type .................................................................63 5.5.7. Renaming a Column ................................................................................85 5.11. Foreign Data .................................................................................................

Notation.........................................................................................53 5. Data Definition....................................................................................... Value...................................................................69 5.5.6. Changing a Column’s Data Type ........................................................................69 5.5.7. Renaming a ................................................................................92 5.11. Foreign Data .................................................................................................

Evaluation Rules ............................................................................40 5. Data Definition....................................................................................... Value...................................................................54 5.5.6. Changing a Column’s Data Type ........................................................................54 5.5.7. Renaming a .............71 6. Data Manipulation........................................................................................................................73 6.1. Inserting Data ...................

Expression Evaluation Rules .....................................................................38 5. Data Definition....................................................................................... Default Value............................................................51 5.5.6. Changing a Column’s Data Type .................................................................51 5.5.7. Renaming a Column ................68 6. Data Manipulation.................................................................................................................69 6.1. Inserting Data .......................

Functions .................................................................................. 51 5. Data Definition ...................................................................................... ................................................................................ 81 5.11. Foreign Data ....................................................................................... 93 5.12. Other PostgreSQL 10.23 Documentation 6. Data Manipulation ............................................................................................ 96 6.1. Inserting Data .................................

Mixed Notation..................................................................................47 5. Data Definition....................................................................................... Default Value............................................................60 5.5.6. Changing a Column’s Data Type .................................................................61 5.5.7. Renaming a Column ................................................................................76 5.10. Foreign Data .................................................................................................