Re: [GENERAL] Synchronous Commit, WAL archiving and statement_timeout - Mailing list pgsql-general

From Michael Paquier
Subject Re: [GENERAL] Synchronous Commit, WAL archiving and statement_timeout
Date
Msg-id CAB7nPqQ=9dnJ7z69FbqSxQo6xJLLutkmmqoYJgrwTR4DwhQOdg@mail.gmail.com
Whole thread Raw
In response to [GENERAL] Synchronous Commit, WAL archiving and statement_timeout  (JP Jacoupy <jpjacoupy@protonmail.com>)
List pgsql-general
On Fri, Feb 3, 2017 at 2:15 AM, JP Jacoupy <jpjacoupy@protonmail.com> wrote:
> I expected the statement to timeout because the synchronous_commit wouldn't
> work since the Slave is down while rollbacking on the Master.

Queries being stuck because of synchronous replication are already
committed locally on the primary when they are waiting for the standby
to confirm that the transaction has been committed as well there,
before sending back confirmation to the client. So statement_timeout
has no effect on in such situations.
--
Michael


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: [GENERAL] Synchronous Commit, WAL archiving and statement_timeout
Next
From: Patrick B
Date:
Subject: [GENERAL] Average - Pg 9.2