Skip to content

Commit 7ae8a99

Browse files
committed
docs: Improve A?synchronous Multimaster Replication descr.
The docs for sync and async multimaster replication were unclear about when to use it, and when it has benefits; this change clarifies that. Reported-by: juha-pekka.eloranta@reaktor.fi Discussion: https://postgr.es/m/156856543824.1274.12180817186798859836@wrigleys.postgresql.org Backpatch-through: 9.4
1 parent 630a8f5 commit 7ae8a99

File tree

1 file changed

+4
-4
lines changed

1 file changed

+4
-4
lines changed

doc/src/sgml/high-availability.sgml

Lines changed: 4 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -219,7 +219,8 @@ protocol to make nodes agree on a serializable transactional order.
219219
<listitem>
220220

221221
<para>
222-
For servers that are not regularly connected, like laptops or
222+
For servers that are not regularly connected or have slow
223+
communication links, like laptops or
223224
remote servers, keeping data consistent among servers is a
224225
challenge. Using asynchronous multimaster replication, each
225226
server works independently, and periodically communicates with
@@ -238,9 +239,8 @@ protocol to make nodes agree on a serializable transactional order.
238239
In synchronous multimaster replication, each server can accept
239240
write requests, and modified data is transmitted from the
240241
original server to every other server before each transaction
241-
commits. Heavy write activity can cause excessive locking,
242-
leading to poor performance. In fact, write performance is
243-
often worse than that of a single server. Read requests can
242+
commits. Heavy write activity can cause excessive locking and
243+
commit delays, leading to poor performance. Read requests can
244244
be sent to any server. Some implementations use shared disk
245245
to reduce the communication overhead. Synchronous multimaster
246246
replication is best for mostly read workloads, though its big

0 commit comments

Comments
 (0)