Re: Synchronous Commit, WAL archiving and statement_timeout

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: JP Jacoupy <jpjacoupy(at)protonmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Synchronous Commit, WAL archiving and statement_timeout
Date: 2017-02-03 02:34:36
Message-ID: CAB7nPqQ=9dnJ7z69FbqSxQo6xJLLutkmmqoYJgrwTR4DwhQOdg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Feb 3, 2017 at 2:15 AM, JP Jacoupy <jpjacoupy(at)protonmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Patrick B 2017-02-03 03:19:27 Average - Pg 9.2
Previous Message Adrian Klaver 2017-02-03 00:15:53 Re: Synchronous Commit, WAL archiving and statement_timeout