Guidance for Develoepers# Designing applications for PGD Preparing your application for PGD Understanding your workload Planning your write strategy Planning your read strategy Designing your schema for replication Accounting for replication behavior Avoiding data anomalies Assessing an existing application for PGD Using pgd assess Reviewing backup strategies Reviewing replication and CDC setups Managing geo-replication When to use geo-replication Deployment workflow 1. Choose a deployment pattern 2. Plan your node distribution and create subgroups 3. Configure routing 4. Configure commit scopes 5. Tune replication and sequences 6. Configure lag control 7. Verify the cluster and prepare for operations Using connection pooling in your application Understanding the active pool mode Adapting your application for transaction mode Managing session parameters Using prepared statements Application use DML and DDL replication and nonreplication DML replication DDL replication Nonreplicated statements Nodes with differences Replicating between nodes with differences Comparison between nodes with differences Replicating between different release levels Timing considerations and synchronous replication Using extensions with PGD PGD and other PostgreSQL extensions Supported extensions Installing extensions Use of table access methods (TAMs) in PGD Feature compatibility Server feature/commit scope interoperability Commit scope/commit scope interoperability
