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 中国用户大会

Platforms ........................................................................... 540 17.7. Platform-Specific Notes ....................................................................... 540 18. Installation ........................................................................ 646 20.13. Version and Platform Compatibility ..................................................... 647 20.14. Error Handling . Logical Decoding Concepts ................................................................ 1433 49.3. Streaming Replication Protocol Interface .............................................. 1435 49.4. Logical

Platforms ........................................................................... 564 17.7. Platform-Specific Notes ....................................................................... 564 18. Installation ........................................................................ 673 20.13. Version and Platform Compatibility ..................................................... 674 20.14. Error Handling . ............................................... 1492 xi PostgreSQL 16.1 Documentation 49.3. Streaming Replication Protocol Interface .............................................. 1493 49.4. Logical

Platforms ........................................................................... 525 16.7. Platform-Specific Notes ....................................................................... 525 17. Installation ........................................................................ 625 19.13. Version and Platform Compatibility ..................................................... 626 19.14. Error Handling . Logical Decoding Concepts ................................................................ 1383 48.3. Streaming Replication Protocol Interface .............................................. 1385 48.4. Logical

Platforms ........................................................................... 472 16.7. Platform-specific Notes ....................................................................... 472 17. Installation ........................................................................ 563 19.13. Version and Platform Compatibility ..................................................... 564 19.14. Error Handling . Logical Decoding Concepts ................................................................ 1275 48.3. Streaming Replication Protocol Interface .............................................. 1277 48.4. Logical

Platforms ................................................................................. 569 17.7. Platform-Specific Notes ............................................................................ 569 ........................................................................ 679 20.13. Version and Platform Compatibility .......................................................... 680 20.14. Error Handling Decoding Concepts ..................................................................... 1512 49.3. Streaming Replication Protocol Interface .................................................... 1513 49.4. Logical

Platforms ........................................................................... 587 17.7. Platform-Specific Notes ....................................................................... 587 18. Server ........................................................................ 693 19.13. Version and Platform Compatibility ..................................................... 694 19.14. Error Handling . Logical Decoding Concepts ................................................................ 1529 47.3. Streaming Replication Protocol Interface .............................................. 1531 xi PostgreSQL

..........................................................449 14.4.7. Disable WAL Archival and Streaming Replication .................................449 14.4.8. Run ANALYZE Afterwards................ ......................................................................................473 16.7. Platform-specific Notes ................................................................................ .........................................................................568 19.13. Version and Platform Compatibility...................................................................569 19.13.1. Previous

Platforms ................................................................................. 595 17.7. Platform-Specific Notes ............................................................................ 596 ........................................................................ 710 20.13. Version and Platform Compatibility .......................................................... 711 vi PostgreSQL 16 Decoding Concepts ..................................................................... 1573 49.3. Streaming Replication Protocol Interface .................................................... 1575 49.4. Logical

Platforms ........................................................................... 548 17.7. Platform-Specific Notes ....................................................................... 548 18. Installation ........................................................................ 656 20.13. Version and Platform Compatibility ..................................................... 657 20.14. Error Handling . ............................................... 1459 xi PostgreSQL 15.5 Documentation 49.3. Streaming Replication Protocol Interface .............................................. 1460 49.4. Logical