Re: When I set the synchronous_standby_names and synchronous_commit to off, the replication query state also show in sync mode.

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: 厚积薄发 <postgresql_2016(at)163(dot)com>
Cc: PostgreSQL mailing lists <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: When I set the synchronous_standby_names and synchronous_commit to off, the replication query state also show in sync mode.
Date: 2016-10-07 00:09:59
Message-ID: CAB7nPqTygL1w8H+y+k0=Ztg9rqJB=2Py8XWvw3HF0Y6FpVoBEw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Fri, Oct 7, 2016 at 9:00 AM, 厚积薄发 <postgresql_2016(at)163(dot)com> wrote:
> It also shows in the sync replication mode, however, it is in the async
> mode. And I can create a table in the primary mode.

This is not a bug, but a design behavior. synchronous_commit can be
used to enforce synchronous replication checks not to happen for
certain transactions. Take for example transactions where temporary or
unlogged tables are created, you don't need to care about the WAL they
generated to be replicated before going back to the client.
--
Michael

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message 厚积薄发 2016-10-07 00:15:30 Re: When I set the synchronous_standby_names and synchronous_commit to off, the replication query state also show in sync mode.
Previous Message 厚积薄发 2016-10-07 00:00:04 When I set the synchronous_standby_names and synchronous_commit to off, the replication query state also show in sync mode.