Concepts

• Terminology
  • Asynchronous replication
  • Commit scopes
  • CAMO or commit-at-most-once
  • Conflicts
  • Consensus
  • Cluster
  • DDL (data definition language)
  • DML (data manipulation language)
  • Eager
  • Eventual consistency
  • Failover
  • Group commit
  • Immediate consistency
  • Logical replication
  • Node
  • Node groups
  • PGD cluster
  • PGD node
  • Physical replication
  • Postgres cluster
  • Quorum
  • Replicated available fault tolerance (Raft)
  • Read scalability
  • Subscription
  • Switchover
  • Synchronous replication
  • Subscriber-only nodes
  • Two-phase commit (2PC)
  • Vertical scaling or scale up
  • Witness nodes
  • Write leader
  • Writer
• PGD overview
  • Basic architecture
    • Multiple groups
    • Multiple masters
    • Asynchronous, by default
    • Mesh topology
    • Logical replication
    • Connection management
    • High availability
  • Architectural options and performance
    • Always On architectures
    • Supported Postgres database servers
    • Characteristics affecting performance