• Engineer at Huawei (USA based) • Co-organizer of NYC PostgreSQL User Group • PostgreSQL-based database clusters • GridSQL • Postgres-XC • Postgres-XL Postgres Conference China 2016 中国用户大会 Agenda be synchronous? • If sharding across multiple instances: – Will you have distributed transactions? – Do you require distributed consistency? – What isolation level is being used? • Will there be a node buffer • Before this, even with synchronous_commit = on, it was possible that after writing to the database and reading from a replica that the data might not yet have be applied.. • Synchronous replication

..............1 1.3. Creating a Database....................................................................................................2 1.4. Accessing a Database ................................ Constraints ..................................................................................60 5.4. System Columns......................................................................................... Privileges................................................................................73 5.8.5. The System Catalog Schema .......................................................................74 5.8.6. Usage

Notice PostgreSQL is Copyright © 1996-2013 by the PostgreSQL Global Development Group and is distributed under the terms of the license of the University of California below. Postgres95 is Copyright ..............1 1.3. Creating a Database....................................................................................................2 1.4. Accessing a Database ................................ ........................................................................................45 5.4. System Columns.........................................................................................

...................... 3 1.3. Creating a Database ................................................................................. 3 1.4. Accessing a Database ........................................ ........................................................................................ 61 5.5. System Columns ................................................................................... 69 5 ............................................................................... 105 5.13. Other Database Objects ....................................................................... 105 iii PostgreSQL

...................... 3 1.3. Creating a Database ................................................................................. 3 1.4. Accessing a Database ........................................ ........................................................................................ 61 5.5. System Columns ................................................................................... 69 5 ............................................................................... 105 5.13. Other Database Objects ....................................................................... 105 iii PostgreSQL

...................... 3 1.3. Creating a Database ................................................................................. 3 1.4. Accessing a Database ........................................ ........................................................................................ 62 5.5. System Columns ................................................................................... 71 5 ............................................................................... 108 5.13. Other Database Objects ....................................................................... 108 iii PostgreSQL

...................... 3 1.3. Creating a Database ................................................................................. 4 1.4. Accessing a Database ........................................ ........................................................................................ 56 5.4. System Columns ................................................................................... 63 5 ................................................................................ 93 5.12. Other Database Objects ......................................................................... 93 5.13. Dependency

Notice PostgreSQL is Copyright © 1996-2013 by the PostgreSQL Global Development Group and is distributed under the terms of the license of the University of California below. Postgres95 is Copyright ...........1 1.3. Creating a Database...........................................................................................................2 1.4. Accessing a Database ............................ ........................................................................................48 5.4. System Columns.........................................................................................

Notice PostgreSQL is Copyright © 1996-2014 by the PostgreSQL Global Development Group and is distributed under the terms of the license of the University of California below. Postgres95 is Copyright ..............1 1.3. Creating a Database....................................................................................................2 1.4. Accessing a Database ................................ ........................................................................................50 5.4. System Columns.........................................................................................

...........1 1.3. Creating a Database...........................................................................................................2 1.4. Accessing a Database ............................ ........................................................................................65 5.4. System Columns......................................................................................... ...................................................................................80 5.8.5. The System Catalog Schema ..............................................................................80 5