Re: [GENERAL] Synchronous Commit, WAL archiving and statement_timeout

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: [GENERAL] Synchronous Commit, WAL archiving and statement_timeout
Дата
Msg-id CAB7nPqQ=9dnJ7z69FbqSxQo6xJLLutkmmqoYJgrwTR4DwhQOdg@mail.gmail.com
обсуждение исходный текст
Ответ на [GENERAL] Synchronous Commit, WAL archiving and statement_timeout  (JP Jacoupy <jpjacoupy@protonmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: [GENERAL] Synchronous Commit, WAL archiving and statement_timeout
Следующее
От: Patrick B
Дата:
Сообщение: [GENERAL] Average - Pg 9.2