From: Arseny Sher <a.sher@postgrespro.ru>
To: pgsql-docs@postgresql.org
Subject: Synchronous logical replication?
Date: Sun, 25 Jun 2017 22:07:38 +0300
Message-ID: <877ezznax1.fsf@ars-thinkpad> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-docs>
devel version of the manual (2017-06-25 12:17:02) contains the following
paragraph documenting the CREATE SUBSCRIPTION command:
synchronous_commit (enum)
....
A different setting might be appropriate when doing synchronous
logical replication. The logical replication workers report the
positions of writes and flushes to the publisher, and when using
synchronous replication, the publisher will wait for the actual
flush. This means that setting synchronous_commit for the subscriber
to off when the subscription is used for synchronous replication
might increase the latency for COMMIT on the publisher. In this
scenario, it can be advantageous to set synchronous_commit to local
or higher.
It seems to me quite confusing.
1) I failed to find in the docs whether logical replication supports
synchronous mode at all and how it is configured.
2) Assuming it is supported, how setting synchronous_commit to off on
replica (subscriber) can increase COMMIT latency on master?
Obviously synchronous mode itself does increase it, but
- In physical replication (docs for synchronous_commit in section
19.5.1) only master's synchronous_commit value determines what
it waits for (e.g. 'remote_write' means writing to replica's OS),
and it seems natural to expect the same behaviour from logical
replication
- Even if replica's synchronous_commit somehow influences this,
'off' value is the lowest and fastest, isn't it?
Arseny Sher
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: a.sher@postgrespro.ru
Subject: Re: Synchronous logical replication?
In-Reply-To: <877ezznax1.fsf@ars-thinkpad>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox