Re: 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: 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:22:06
Message-ID: CAB7nPqTbfGLvLLcLqy0J4FQOfvnkPGrVpFqNRJL_03TLhoTCQQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Fri, Oct 7, 2016 at 9:15 AM, 厚积薄发 <postgresql_2016(at)163(dot)com> wrote:
> I know that. My question is when I use the reload method to change the
> synchronous_commit(from on to off), but the query replication state seems
> not change. Although it is in the async mode, it shows in the sync mode.

And you didn't get my point :)
synchronous_commit has no effect on what is showing in
pg_stat_replication or in the way priorities are calculated for each
standby connected. It just influences the local status of a syncrep
wait.
--
Michael

In response to

Browse pgsql-bugs by date

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