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