2018年PostgreSQL中国技术大会 主要业务场景 • IM工具+SCRM系统（高并发、低延迟、稳定） • 大量客户需要私有化云服务器部署（云更新） • 需求变更频繁，不适合关系型数据库 2018年PostgreSQL中国技术大会 目前服务器架构 2018年PostgreSQL中国技术大会 MySQL应用史 • 最开始做的站群系统WEB端使用MySQL： • copy简单快速，批量复制，替换修改简单； MongoDB存储，减轻MySQL负担； • 这种方式虽然可以暂时解决问题，我们自己用也没有任何 问题，可以结合各自数据库优点，发挥性能。但是我们有 很多客户是需要私有化部署数据库，让每家客户都接受这 种方式，会为甲方增加很多服务器以及运维成本，可能客 户数据量很少，也需要使用双数据库，更新运维都比较麻 烦。 2018年PostgreSQL中国技术大会 PgSQL≈MySQL+MongoDB • 个人认为，PgSQL结合了MySQL关系型数据库事务处理能力

resolution after commit time (last one wins by default) • Carefully read more about potential issues: http://bdr-project.org/docs/stable/conflicts-types.html May be best to try to avoid conflicts if possible Conference China 2016 中国用户大会 Solutions: Custom Schema-level Sharding • Popularized by Instagram – http://media.postgresql.org/sfpug/Instagram_sfpug.pdf • Use schema for shards • Create many logical shards postgres_fdw or PL/Proxy could be used Other • Postgres-XL (The PostgreSQL License) • Greenplum (Apache License) Postgres Conference China 2016 中国用户大会 Mixed Workload – HTAP Hybrid Transactional Analytical

30–50% faster on the Wisconsin 2 https://www.ibm.com/analytics/informix 3 https://www.ibm.com/ 4 http://meteora.ucsd.edu/s2k/s2k_home.html xxxv Preface Benchmark compared to POSTGRES, Version 4.2. o xmlns:pg="http:// postgresql.org/stuff">bar'); xml_is_well_formed_document ----------------------------- t (1 row) SELECT xml_is_well_formed_document('http:// example.com">test', ARRAY[ARRAY['my', 'http://example.com']]); xpath -------- {test} (1 row) To deal with

programs with the Postgres95 server. 2 https://www.ibm.com/analytics/informix 3 https://www.ibm.com/ 4 http://meteora.ucsd.edu/s2k/s2k_home.html xxxiii Preface • The large-object interface was overhauled o xmlns:pg="http:// postgresql.org/stuff">bar'); xml_is_well_formed_document ----------------------------- t (1 row) SELECT xml_is_well_formed_document('http:// example.com">test', ARRAY[ARRAY['my', 'http://example.com']]); xpath -------- {test} (1 row) To deal with

programs with the Postgres95 server. 2 https://www.ibm.com/analytics/informix 3 https://www.ibm.com/ 4 http://meteora.ucsd.edu/s2k/s2k_home.html xxxiii Preface • The large-object interface was overhauled o xmlns:pg="http:// postgresql.org/stuff">bar'); xml_is_well_formed_document ----------------------------- t (1 row) SELECT xml_is_well_formed_document('http:// example.com">test', ARRAY[ARRAY['my', 'http://example.com']]); xpath -------- {test} (1 row) To deal with

30–50% faster on the Wisconsin 2 https://www.ibm.com/analytics/informix 3 https://www.ibm.com/ 4 http://meteora.ucsd.edu/s2k/s2k_home.html xxxv Preface Benchmark compared to POSTGRES, Version 4.2. o xmlns:pg="http:// postgresql.org/stuff">bar'); xml_is_well_formed_document ----------------------------- t (1 row) SELECT xml_is_well_formed_document('http:// example.com">test', ARRAY[ARRAY['my', 'http://example.com']]); xpath -------- {test} (1 row) To deal with

maintainability. Postgres95 release 1.0.x ran about 30-50% faster on the Wisconsin 2 http://www.informix.com/ 3 http://www.ibm.com/ 4 http://meteora.ucsd.edu/s2k/s2k_home.html xxxiii Preface Benchmark compared you wish to subscribe to the lists, please visit https://lists.postgresql.org/ for instructions. 9 http://www.chiark.greenend.org.uk/~sgtatham/bugs.html 10 https://www.postgresql.org/ xxxviii Part I. o xmlns:pg="http:// postgresql.org/stuff">bar'); xml_is_well_formed_document ----------------------------- t (1 row) SELECT xml_is_well_formed_document('0 码力 | 2727 页 | 11.93 MB | 1 年前

3

new Tcl commands to interface Tcl programs with the Postgres95 server. 2 http://www.informix.com/ 3 http://www.ibm.com/ 4 http://meteora.ucsd.edu/s2k/s2k_home.html xxxi Preface • The large-object interface bug report this way causes it to be mailed to the mailing list. 9 http://www.chiark.greenend.org.uk/~sgtatham/bugs.html 10 https://www.postgresql.org/ xxxv Preface If o xmlns:pg="http:// postgresql.org/stuff">bar'); xml_is_well_formed_document ----------------------------- t (1 row) SELECT xml_is_well_formed_document('0 码力 | 2590 页 | 12.03 MB | 1 年前

3

by adding new • data types • functions • operators • aggregate functions • index methods 1. http://db.cs.berkeley.edu/postgres.html lxiv Preface • procedural languages And because of the liberal burden, the Berkeley POSTGRES project officially ended with Version 4.2. 2. http://www.informix.com/ 3. http://www.ibm.com/ 4. http://meteora.ucsd.edu/s2k/s2k_home.html lxv Preface 2.2. Postgres95 In . Please be specific about what part of the documentation you are unhappy with. 9. http://www.chiark.greenend.org.uk/~sgtatham/bugs.html 10. https://www.postgresql.org/ lxx Preface If

PostgreSQL can be extended by the user in many ways, for example by adding new • data types 1. http://db.cs.berkeley.edu/postgres.html lxix Preface • functions • operators • aggregate functions and support was taking up large amounts of time that should have been 2. http://www.informix.com/ 3. http://www.ibm.com/ 4. http://meteora.ucsd.edu/s2k/s2k_home.html lxx Preface devoted to database requested to use a descriptive subject for your email message, perhaps parts of the error message. 9. http://www.chiark.greenend.org.uk/~sgtatham/bugs.html lxxv Preface Another method is to fill in the