2018年PostgreSQL中国技术大会 为什么我们抛弃MongoDB和 MySQL，选择PgSQL 张启程 qc@aochuang.cn 奥创软件研究院（上海）研发中心 2018年PostgreSQL中国技术大会 任何数据库都很好用 • 我不是一个专业的DBA ，对数据库的理解不够深入，也不 一定准确，在此抛砖引玉，只是结合我们团队业务场景来 分享下我们选择数据库的过程。 • 2018年PostgreSQL中国技术大会 PgSQL≈MySQL+MongoDB • 个人认为，PgSQL结合了MySQL关系型数据库事务处理能力 以及MongoDB的大数据处理能力。稳定性强，高并发，支 持JSON,扩展字段特别方便。 • 我们团队没有大量专业的DBA运维人员，业务迭代也非常 快，需求变更频繁，对数据库非常依赖，用了PgSQL之后， 感觉可以充分满足我们的需求。 2018年PostgreSQL中国技术大会 2018年PostgreSQL中国技术大会 关于PgSQL运维 • 由于我们团队没有大量特别专业的DBA，我们服务的客户 甚至连运维人员都没有！而我们的业务又必须保障绝对稳 定，经过反复尝试，我们放弃了自建数据库的方式（坑太 多！填不完） • 目前所有业务全部使用阿里云的PgSQL，针对不同客户的业 务量大小，选择不同配置的数据库，开通简单，拓展扩容 方便。我们的客户也不需要太专业的运维人员就可以直接

Languages .................................................................................559 35. PL/pgSQL - SQL Procedural Language ....................................................................... .............................................................561 35.1.1. Advantages of Using PL/pgSQL ....................................................................562 35.1.2. Supported Argument Data Types..................................................562 35.2. Tips for Developing in PL/pgSQL...............................................................................563 35.2.1. Handling

Procedural Languages ..........................................................................528 35. PL/pgSQL - SQL Procedural Language ....................................................................... .............................................................530 35.1.1. Advantages of Using PL/pgSQL .............................................................531 35.1.2. Supported Argument and Result Result Data Types...........................................531 35.2. Tips for Developing in PL/pgSQL........................................................................532 35.2.1. Handling of Quotation

Languages .................................................................................598 36. PL/pgSQL - SQL Procedural Language ....................................................................... .............................................................600 36.1.1. Advantages of Using PL/pgSQL ....................................................................601 36.1.2. Supported Argument Data Types..................................................601 36.2. Tips for Developing in PL/pgSQL...............................................................................602 36.2.1. Handling

Languages .................................................................................601 36. PL/pgSQL - SQL Procedural Language ....................................................................... .............................................................603 36.1.1. Advantages of Using PL/pgSQL ....................................................................604 36.1.2. Supported Argument Data Types..................................................604 36.2. Tips for Developing in PL/pgSQL...............................................................................605 36.2.1. Handling

Languages .................................................................................672 37. PL/pgSQL - SQL Procedural Language ....................................................................... .............................................................674 37.1.1. Advantages of Using PL/pgSQL ....................................................................675 37.1.2. Supported Argument Data Types..................................................675 37.2. Tips for Developing in PL/pgSQL...............................................................................676 37.2.1. Handling

Languages .................................................................................763 38. PL/pgSQL - SQL Procedural Language ....................................................................... .............................................................765 38.1.1. Advantages of Using PL/pgSQL ....................................................................765 38.1.2. Supported Argument and Result Data Types..................................................766 38.2. Structure of PL/pgSQL................................................................................................766

Procedural Languages ..........................................................................721 38. PL/pgSQL - SQL Procedural Language ....................................................................... PL/pgSQL .............................................................723 38.1.2. Supported Argument and Result Data Types...........................................723 38.2. Structure of PL/pgSQL... ...................................................................................751 38.10. PL/pgSQL Under the Hood................................................................................756

Languages .................................................................................672 37. PL/pgSQL - SQL Procedural Language ....................................................................... .............................................................674 37.1.1. Advantages of Using PL/pgSQL ....................................................................675 37.1.2. Supported Argument Data Types..................................................675 37.2. Tips for Developing in PL/pgSQL...............................................................................676 37.2.1. Handling

Languages .................................................................................839 38. PL/pgSQL - SQL Procedural Language ....................................................................... .............................................................841 38.1.1. Advantages of Using PL/pgSQL ....................................................................841 38.1.2. Supported Argument and Result Data Types..................................................842 38.2. Structure of PL/pgSQL................................................................................................842