2018年PostgreSQL中国技术大会 为什么我们抛弃MongoDB和 MySQL，选择PgSQL 张启程 qc@aochuang.cn 奥创软件研究院（上海）研发中心 2018年PostgreSQL中国技术大会 任何数据库都很好用 • 我不是一个专业的DBA ，对数据库的理解不够深入，也不 一定准确，在此抛砖引玉，只是结合我们团队业务场景来 分享下我们选择数据库的过程。 • 2018年PostgreSQL中国技术大会 MySQL应用史 • 最开始做的站群系统WEB端使用MySQL： • copy简单快速，批量复制，替换修改简单； • 每个网站一个库，单体数据量小，数据类型固定； • 后来做SCRM系统，也首选MySQL： • 需求经常改动，每次改需求先改数据库； • 数据量越来越大，越来越不了解这只海豚； 2018年PostgreSQL中国技术大会 MySQL+MongoDB • • 迫于无奈，分拆数据，将需要用到事务、调用频繁的数据 继续用MySQL,将IM中聊天记录等数据量大的数据，用 MongoDB存储，减轻MySQL负担； • 这种方式虽然可以暂时解决问题，我们自己用也没有任何 问题，可以结合各自数据库优点，发挥性能。但是我们有 很多客户是需要私有化部署数据库，让每家客户都接受这 种方式，会为甲方增加很多服务器以及运维成本，可能客 户数据量很少，也需要使用双数据库，更新运维都比较麻

Expression Matching Rules....................................................145 9.7.3.6. Limits and Compatibility .....................................................................146 9.7.3.7. Basic Regular ...........................................................272 16.4.10. Version and Platform Compatibility .............................................................273 16.4.10.1. Previous PostgreSQL Versions.........................................................273 16.4.10.2. Platform and Client Compatibility ...................................................273 16.4.11. Preset Options..............

Expression Matching Rules.............................................138 9.7.3.6. Limits and Compatibility ..............................................................139 9.7.3.7. Basic Regular Expressions ...........................................................258 16.4.10. Version and Platform Compatibility ......................................................258 16.4.10.1. Previous PostgreSQL Versions Versions..................................................258 16.4.10.2. Platform and Client Compatibility ............................................259 16.4.11. Preset Options........................

Expression Matching Rules....................................................155 9.7.3.6. Limits and Compatibility .....................................................................156 9.7.3.7. Basic Regular .............................................................308 17.12. Version and Platform Compatibility..........................................................................308 17.12.1. Previous ............................................................309 17.12.2. Platform and Client Compatibility................................................................309 17.13. Preset Options....

Expression Matching Rules....................................................155 9.7.3.6. Limits and Compatibility .....................................................................157 9.7.3.7. Basic Regular .............................................................309 17.12. Version and Platform Compatibility..........................................................................309 17.12.1. Previous ............................................................310 17.12.2. Platform and Client Compatibility................................................................311 17.13. Preset Options....

Expression Matching Rules....................................................160 9.7.3.6. Limits and Compatibility .....................................................................161 9.7.3.7. Basic Regular .............................................................325 17.12. Version and Platform Compatibility..........................................................................326 17.12.1. Previous ............................................................326 17.12.2. Platform and Client Compatibility................................................................327 17.13. Preset Options....

Expression Matching Rules....................................................160 9.7.3.6. Limits and Compatibility .....................................................................161 9.7.3.7. Basic Regular .............................................................325 17.12. Version and Platform Compatibility..........................................................................326 17.12.1. Previous ............................................................326 17.12.2. Platform and Client Compatibility................................................................327 17.13. Preset Options....

Expression Matching Rules....................................................188 9.7.3.6. Limits and Compatibility .....................................................................190 9.7.3.7. Basic Regular .............................................................441 18.12. Version and Platform Compatibility..........................................................................442 18.12.1. Previous ............................................................442 18.12.2. Platform and Client Compatibility................................................................444 18.13. Preset Options....

Expression Matching Rules.............................................177 9.7.3.6. Limits and Compatibility ..............................................................178 9.7.3.7. Basic Regular Expressions .............................................................416 18.12. Version and Platform Compatibility...................................................................416 18.12.1. Previous PostgreSQL ............................................................417 18.12.2. Platform and Client Compatibility.........................................................418 18.13. Preset Options...........

Expression Matching Rules....................................................196 9.7.3.6. Limits and Compatibility .....................................................................197 9.7.3.7. Basic Regular .............................................................461 18.12. Version and Platform Compatibility..........................................................................461 18.12.1. Previous ............................................................462 18.12.2. Platform and Client Compatibility................................................................463 18.13. Preset Options....