2018年PostgreSQL中国技术大会 为什么我们抛弃MongoDB和 MySQL，选择PgSQL 张启程 qc@aochuang.cn 奥创软件研究院（上海）研发中心 2018年PostgreSQL中国技术大会 任何数据库都很好用 • 我不是一个专业的DBA ，对数据库的理解不够深入，也不 一定准确，在此抛砖引玉，只是结合我们团队业务场景来 分享下我们选择数据库的过程。 •

pg_replication_slots; • 查看是否创建成功。 • pg_logical_slot_get_changes • 返回槽slot_name中的改变，从上一次已经被消费的点开始返回。 pg_logical_slot_peek_changes • 参数和行为就像pg_logical_slot_get_changes()函数，不过改变不会被 消费，即在未来的调用中还会返回这些改变。 2016Postgres中国用户大会 Postgres Conference China 2016 中国用户大会 使用限制 目前不支持DDL的解析, 只有DML的解析 如：create，drop TEMPORARY表和UNLOGGED表不会被复制 表必须有主键或者唯一约束，否则像update或 者delete这样的操作无法被复制 2016Postgres中国用户大会 Postgres Conference

个人介绍 缪长风 ⚫ 2010年初加入支付宝，负责Oracle RAC和Greenplum数据仓库 ⚫ 有幸参与了Oracle RAC到 Greenplum再到Hadoop以及最终到 ODPS的架构演进工作。 ⚫ 2012年起，转至阿里巴巴大数据团队，负责Hbase/OTS业务支 撑，期间多次负责阿里大数据双11架构和稳定性工作 ⚫ 2018年，在阿里云数据库负责OLAP产品管理团队。 （云Greenplum）低成本，快速 构筑在线企业数据仓库。 • 应用易开发、适配 支持SQL 2003，部分兼容Oracle语法， 支持PL/SQL 存储过程，OLAP窗口函数，事务及数据库标准隔离级别 完备功能和生态，实现应用快速迁移或适配 • PB级数据秒级响应 MPP水平扩展架构，PB级数据查询秒级响应；向量化计算，及列存储智能索引，领先传统数据库引擎性能 3x； 新一代SQL优化器，实现复杂分析语句免调优 分 区 分 区 计算组 分 区 分 区 分 区 分 区 计算组 分 区 分 区 分 区 分 区 计算组 AnalyticDB for PostgreSQL 公共云产品规格和实例选型： 【高性能】计算组 CPU/核 内存 用户数据空间 1x2C SSD 2 16GB 160GB SSD 1x16C SSD 16 128GB 1.28TB SSD 4x4C SSD 16

Installation Procedure .......................................................................... 457 16.5. Post-Installation Setup ......................................................................... 470 16 should have been devoted to database research. In an effort to reduce this support burden, the Berkeley POST- GRES project officially ended with Version 4.2. 2.2. Postgres95 In 1994, Andrew Yu and Jolly Chen Where to Report Bugs In general, send bug reports to the bug report mailing list at post- gresql.org>. You are requested to use a descriptive subject for your email message, perhaps parts

Procedure ............................................................................... 481 16.5. Post-Installation Setup .............................................................................. Ver- sion 4.21, developed at the University of California at Berkeley Computer Science Department. POST- GRES pioneered many concepts that only became available in some commercial database systems much PostgreSQL The object-relational database management system now known as PostgreSQL is derived from the POST- GRES package written at the University of California at Berkeley. With over two decades of development

Installation Procedure .......................................................................... 506 16.5. Post-Installation Setup ......................................................................... 521 16 should have been devoted to database research. In an effort to reduce this support burden, the Berkeley POST- GRES project officially ended with Version 4.2. 2.2. Postgres95 In 1994, Andrew Yu and Jolly Chen Where to Report Bugs In general, send bug reports to the bug report mailing list at post- gresql.org>. You are requested to use a descriptive subject for your email message, perhaps parts

Installation Procedure .......................................................................... 485 16.5. Post-Installation Setup ......................................................................... 500 16 should have been devoted to database research. In an effort to reduce this support burden, the Berkeley POST- GRES project officially ended with Version 4.2. 2.2. Postgres95 In 1994, Andrew Yu and Jolly Chen Where to Report Bugs In general, send bug reports to the bug report mailing list at post- gresql.org>. You are requested to use a descriptive subject for your email message, perhaps parts

Procedure ............................................................................... 534 16.5. Post-Installation Setup .............................................................................. Ver- sion 4.21, developed at the University of California at Berkeley Computer Science Department. POST- GRES pioneered many concepts that only became available in some commercial database systems much PostgreSQL The object-relational database management system now known as PostgreSQL is derived from the POST- GRES package written at the University of California at Berkeley. With decades of development behind

Installation Procedure .......................................................................... 526 17.5. Post-Installation Setup ......................................................................... 539 17 should have been devoted to database research. In an effort to reduce this support burden, the Berkeley POST- GRES project officially ended with Version 4.2. 2.2. Postgres95 In 1994, Andrew Yu and Jolly Chen Where to Report Bugs In general, send bug reports to the bug report mailing list at post- gresql.org>. You are requested to use a descriptive subject for your email message, perhaps parts

Building and Installation with Meson ..................................................... 574 17.5. Post-Installation Setup ......................................................................... 585 17 should have been devoted to database research. In an effort to reduce this support burden, the Berkeley POST- GRES project officially ended with Version 4.2. 2.2. Postgres95 In 1994, Andrew Yu and Jolly Chen Where to Report Bugs In general, send bug reports to the bug report mailing list at post- gresql.org>. You are requested to use a descriptive subject for your email message, perhaps parts