Question
Physical streaming replication versus logical replication: what differs and when should each be used?
Answer
Physical replication replays WAL for the whole cluster and supports standby promotion. Logical replication sends changes for selected published tables. Use physical replication for HA and read standbys; use logical replication for selective data distribution or migrations.