> On Jan 5, 2023, at 19:38, Bhautik Chudasama <bhautikrchudasama@xxxxxxxxx> wrote: > > Does it mean when we commit transaction, client will wait until all replicas successfully committed the transaction. It depends. If all the settings are the defaults, no, the client won't wait for the replicas to acknowledge the commit of the transaction. This is asynchronous replication. Synchronous replication can be set up, though, in which case the client will wait until some or all of the replicas have reported back that they've committed, depending on how it is configured. The documentation explains the detailsl: https://www.postgresql.org/docs/current/warm-standby.html#SYNCHRONOUS-REPLICATION
