| From: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
|---|---|
| To: | amutu(at)amutu(dot)com |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #11517: the pg_stat_replication.sync_stat show sync when synchronous_commit is set to be off |
| Date: | 2014-09-29 08:02:44 |
| Message-ID: | CAB7nPqRQ_mp65oR=B9LVr5eeBwjLk8RD3X4trymdG=8ydTHp-A@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Mon, Sep 29, 2014 at 4:45 PM, <amutu(at)amutu(dot)com> wrote:
> from the doc,when synchronous_commit set to off or local,the commit will
> not
> wait the remote slave reveive data,so it is not asynchronous
> replication.but I
> find the pg_stat_replication wrongly report the sync_stat to sync.This can
This is not a bug, please refer to the documentation about
synchronous_commit:
http://www.postgresql.org/docs/devel/static/runtime-config-wal.html#GUC-SYNCHRONOUS-COMMIT
When synchronous_commit is set to off, local or remote_write, the master
node does not wait for the confirmation from the sync standby that the WAL
has been flushed to disk (for remote_write it waits for the write
confirmation), and the standby is still considered as sync, of course if
synchronous_standby_names is set.
Regards,
--
Michael
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jov | 2014-09-29 09:22:46 | Re: BUG #11517: the pg_stat_replication.sync_stat show sync when synchronous_commit is set to be off |
| Previous Message | Michael Paquier | 2014-09-29 07:51:49 | Re: BUG #11457: The below query crashes 9.3.5, but not 9.3.4 |