On Fri, Feb 3, 2017 at 2:15 AM, JP Jacoupy <jpjacoupy@xxxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
