Re: [HACKERS] logical replication apply to run with sync commit offby default - Mailing list pgsql-hackers

From Craig Ringer
Subject Re: [HACKERS] logical replication apply to run with sync commit offby default
Date
Msg-id CAMsr+YGPF7tSN7U8bYxe169btb25rS9Z_rS5hsxzHQCezySadQ@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] logical replication apply to run with sync commit offby default  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
List pgsql-hackers
On 7 April 2017 at 01:38, Peter Eisentraut
<peter.eisentraut@2ndquadrant.com> wrote:

> I think this change could use some more documentation.  Under what
> circumstances would a user want to turn this back on?

The main reason is if you want to use synchronous_standby_names and
synchronous commit on the upstream. Turning sync appy back on for
logical replicas will cause them to send more timely standby status
updates, so commits on the upstream can return faster.

-- Craig Ringer                   http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training & Services



pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: [HACKERS] Implementation of SASLprep for SCRAM-SHA-256
Next
From: Andrew Dunstan
Date:
Subject: Re: [HACKERS] PATCH: recursive json_populate_record()