Glossary / Replication

Replication

Practical PostgreSQL glossary entry with a clear definition, example, and benchmarking context.

What Is Replication?

Replication copies data from one PostgreSQL server (primary) to others (replicas). PostgreSQL supports streaming and logical replication. It's essential for high availability and read scaling.

Why It Matters for PostgreSQL Performance

In PostgreSQL performance work, Replication affects throughput, latency, or operational reliability depending on workload and configuration.

Practical Benchmarking Context

When benchmarking with pgbench, track how Replication changes behavior across scale factor, client concurrency, and storage conditions.

Use this term together with workload shape, concurrency level, and scale factor when interpreting pgbench outputs. Isolated values can be misleading without full run context.

Example

Types: Streaming Replication, Logical Replication

Related Resources