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 – No global sequences • pglogical extension for logical replication – Physical (block level) streaming replication replicates everything – pglogical’s logical replication permits selective replication OLAP • OLTP write and read scalability • Custer-wide ACID properties • Can also act as distributed key-value store • Currently based on PostgreSQL 9.5 Postgres Conference China 2016 中国用户大会

............................................... 1492 xi PostgreSQL 16.1 Documentation 49.3. Streaming Replication Protocol Interface .............................................. 1493 49.4. Logical 8. Synchronous Replication Support for Logical Decoding ........................... 1502 49.9. Streaming of Large Transactions for Logical Decoding ............................ 1503 49.10. Two-phase Commit ............................ 2342 55.4. Streaming Replication Protocol ........................................................... 2343 55.5. Logical Streaming Replication Protocol ...................

Logical Decoding Concepts ................................................................ 1433 49.3. Streaming Replication Protocol Interface .............................................. 1435 49.4. Logical 8. Synchronous Replication Support for Logical Decoding ........................... 1443 49.9. Streaming of Large Transactions for Logical Decoding ............................ 1444 49.10. Two-phase Commit ............................ 2249 53.4. Streaming Replication Protocol ........................................................... 2251 53.5. Logical Streaming Replication Protocol ...................

Logical Decoding Concepts ................................................................ 1383 48.3. Streaming Replication Protocol Interface .............................................. 1385 48.4. Logical ............................ 2168 52.4. Streaming Replication Protocol ........................................................... 2169 52.5. Logical Streaming Replication Protocol ................... procedural languages And because of the liberal license, PostgreSQL can be used, modified, and distributed by anyone free of charge for any purpose, be it private, commercial, or academic. 2. A Brief History

Logical Decoding Concepts ................................................................ 1275 48.3. Streaming Replication Protocol Interface .............................................. 1277 48.4. Logical ............................ 2009 52.4. Streaming Replication Protocol ........................................................... 2010 52.5. Logical Streaming Replication Protocol ................... procedural languages And because of the liberal license, PostgreSQL can be used, modified, and distributed by anyone free of charge for any purpose, be it private, commercial, or academic. 2. A Brief History

Decoding Concepts ..................................................................... 1573 49.3. Streaming Replication Protocol Interface .................................................... 1575 49.4. Logical Synchronous Replication Support for Logical Decoding ................................ 1584 49.9. Streaming of Large Transactions for Logical Decoding ................................. 1584 49.10. Two-phase ......................... 2469 55.4. Streaming Replication Protocol ................................................................. 2471 55.5. Logical Streaming Replication Protocol ................

Logical Decoding Concepts ................................................................ 1529 47.3. Streaming Replication Protocol Interface .............................................. 1531 xi PostgreSQL 8. Synchronous Replication Support for Logical Decoding ........................... 1540 47.9. Streaming of Large Transactions for Logical Decoding ............................ 1540 47.10. Two-phase Commit PostgreSQL 17beta1 Documentation 53.4. Streaming Replication Protocol ........................................................... 2402 53.5. Logical Streaming Replication Protocol ...................

............................................... 1459 xi PostgreSQL 15.5 Documentation 49.3. Streaming Replication Protocol Interface .............................................. 1460 49.4. Logical 8. Synchronous Replication Support for Logical Decoding ........................... 1469 49.9. Streaming of Large Transactions for Logical Decoding ............................ 1469 49.10. Two-phase Commit ............................ 2298 55.4. Streaming Replication Protocol ........................................................... 2300 55.5. Logical Streaming Replication Protocol ...................

..........................................................449 14.4.7. Disable WAL Archival and Streaming Replication .................................449 14.4.8. Run ANALYZE Afterwards................ a Standby Server....................................................................651 26.2.5. Streaming Replication..............................................................................652 26 ..............................................................................1290 xxv 47.3. Streaming Replication Protocol Interface ..........................................................1290 47

Decoding Concepts ..................................................................... 1512 49.3. Streaming Replication Protocol Interface .................................................... 1513 49.4. Logical Synchronous Replication Support for Logical Decoding ................................ 1522 49.9. Streaming of Large Transactions for Logical Decoding ................................. 1523 49.10. Two-phase ......................... 2377 53.4. Streaming Replication Protocol ................................................................. 2378 53.5. Logical Streaming Replication Protocol ................