pgsql: Ignore recovery_min_apply_delay until recovery has reached consi

Поиск
Список
Период
Сортировка
От Fujii Masao
Тема pgsql: Ignore recovery_min_apply_delay until recovery has reached consi
Дата
Msg-id E1acGFd-0001tC-0z@gemulon.postgresql.org
обсуждение исходный текст
Список pgsql-committers
Ignore recovery_min_apply_delay until recovery has reached consistent state

Previously recovery_min_apply_delay was applied even before recovery
had reached consistency. This could cause us to wait a long time
unexpectedly for read-only connections to be allowed. It's problematic
because the standby was useless during that wait time.

This patch changes recovery_min_apply_delay so that it's applied once
the database has reached the consistent state. That is, even if the delay
is set, the standby tries to replay WAL records as fast as possible until
it has reached consistency.

Author: Michael Paquier
Reviewed-By: Julien Rouhaud
Reported-By: Greg Clough
Backpatch: 9.4, where recovery_min_apply_delay was added
Bug: #13770
Discussion: http://www.postgresql.org/message-id/20151111155006.2644.84564@wrigleys.postgresql.org

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/d34794f7d5566effd342dd0ebaca3de3b48656f0

Modified Files
--------------
doc/src/sgml/recovery-config.sgml | 5 +++--
src/backend/access/transam/xlog.c | 4 ++++
2 files changed, 7 insertions(+), 2 deletions(-)


В списке pgsql-committers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: pgsql: Make stats regression test robust in the face of parallel query.
Следующее
От: Fujii Masao
Дата:
Сообщение: pgsql: Ignore recovery_min_apply_delay until recovery has reached consi