Scaling with PostgreSQL 9.6 and Postgres-XL Mason Sharp mason.sharp@gmail.com Huawei Postgres Conference China 2016 中国用户大会 whoami • Engineer at Huawei (USA based) • Co-organizer of NYC PostgreSQL User Group Group • PostgreSQL-based database clusters • GridSQL • Postgres-XC • Postgres-XL Postgres Conference China 2016 中国用户大会 Agenda • PostgreSQL 9.6 Scaling Features • Scaling Solutions • Use Cases • Postgres-XL is acceptable latency? – What is acceptable in a network partition? • Do you require using only PostgreSQL binaries and extensions, or are can you utilize other projects? Postgres Conference China 2016

PostgreSQL 10.23 Documentation The PostgreSQL Global Development Group PostgreSQL 10.23 Documentation The PostgreSQL Global Development Group Copyright © 1996-2022 The PostgreSQL Global Development Group Group Legal Notice PostgreSQL is Copyright © 1996-2022 by the PostgreSQL Global Development Group. Postgres95 is Copyright © 1994-5 by the Regents of the University of California. Permission to use ........... xxxii 1. What is PostgreSQL? .......................................................................................... xxxii 2. A Brief History of PostgreSQL .............................

PostgreSQL 16.1 Documentation The PostgreSQL Global Development Group PostgreSQL 16.1 Documentation The PostgreSQL Global Development Group Copyright © 1996–2023 The PostgreSQL Global Development Group Group Legal Notice PostgreSQL is Copyright © 1996–2023 by the PostgreSQL Global Development Group. Postgres95 is Copyright © 1994–5 by the Regents of the University of California. Permission to use, ............ xxxiv 1. What Is PostgreSQL? ......................................................................................... xxxiv 2. A Brief History of PostgreSQL .............................

PostgreSQL 11.22 Documentation The PostgreSQL Global Development Group PostgreSQL 11.22 Documentation The PostgreSQL Global Development Group Copyright © 1996-2023 The PostgreSQL Global Development Group Group Legal Notice PostgreSQL is Copyright © 1996-2023 by the PostgreSQL Global Development Group. Postgres95 is Copyright © 1994-5 by the Regents of the University of California. Permission to use ............... xxxi 1. What is PostgreSQL? ..................................................................................... xxxi 2. A Brief History of PostgreSQL ................................

PostgreSQL 10.23 Documentation The PostgreSQL Global Development Group PostgreSQL 10.23 Documentation The PostgreSQL Global Development Group Copyright © 1996-2022 The PostgreSQL Global Development Group Group Legal Notice PostgreSQL is Copyright © 1996-2022 by the PostgreSQL Global Development Group. Postgres95 is Copyright © 1994-5 by the Regents of the University of California. Permission to use ................ xxx 1. What is PostgreSQL? ...................................................................................... xxx 2. A Brief History of PostgreSQL ................................

PostgreSQL 9.0.22 Documentation The PostgreSQL Global Development Group PostgreSQL 9.0.22 Documentation by The PostgreSQL Global Development Group Copyright © 1996-2015 The PostgreSQL Global Development Development Group Legal Notice PostgreSQL is Copyright © 1996-2015 by the PostgreSQL Global Development Group and is distributed under the terms of the license of the University of California below. Postgres95 .. lvi 1. What is PostgreSQL?.................................................................................................................. lvi 2. A Brief History of PostgreSQL...................

PostgreSQL 14.10 Documentation The PostgreSQL Global Development Group PostgreSQL 14.10 Documentation The PostgreSQL Global Development Group Copyright © 1996–2023 The PostgreSQL Global Development Group Group Legal Notice PostgreSQL is Copyright © 1996–2023 by the PostgreSQL Global Development Group. Postgres95 is Copyright © 1994–5 by the Regents of the University of California. Permission to use ............ xxxiv 1. What Is PostgreSQL? ......................................................................................... xxxiv 2. A Brief History of PostgreSQL .............................

PostgreSQL 9.2.24 Documentation The PostgreSQL Global Development Group PostgreSQL 9.2.24 Documentation by The PostgreSQL Global Development Group Copyright © 1996-2017 The PostgreSQL Global Development Development Group Legal Notice PostgreSQL is Copyright © 1996-2017 by the PostgreSQL Global Development Group. Postgres95 is Copyright © 1994-5 by the Regents of the University of California. Permission to ......lxi 1. What is PostgreSQL?............................................................................................................lxi 2. A Brief History of PostgreSQL.......................

PostgreSQL 9.4.26 Documentation The PostgreSQL Global Development Group PostgreSQL 9.4.26 Documentation by The PostgreSQL Global Development Group Copyright © 1996-2020 The PostgreSQL Global Development Development Group Legal Notice PostgreSQL is Copyright © 1996-2020 by the PostgreSQL Global Development Group. Postgres95 is Copyright © 1994-5 by the Regents of the University of California. Permission to ...xlv 1. What is PostgreSQL?..................................................................................................................xlv 2. A Brief History of PostgreSQL....................

PostgreSQL 9.0.22 Documentation The PostgreSQL Global Development Group PostgreSQL 9.0.22 Documentation by The PostgreSQL Global Development Group Copyright © 1996-2015 The PostgreSQL Global Development Development Group Legal Notice PostgreSQL is Copyright © 1996-2015 by the PostgreSQL Global Development Group and is distributed under the terms of the license of the University of California below. Postgres95 ......lii 1. What is PostgreSQL?.............................................................................................................lii 2. A Brief History of PostgreSQL......................