hot standby term

replica accepting read queries while replicating

Postgres replicas can serve reads. Useful for offloading analytics, reporting. Trade-off: long-running queries on standby can block replication if conflicts arise.

topics: databases, postgres, replication

references:

Postgres — Hot Standby