pgsql: Ignore recovery_min_apply_delay until recovery has reached consi

From: Fujii Masao <fujii(at)postgresql(dot)org>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Ignore recovery_min_apply_delay until recovery has reached consi
Date: 2016-03-05 17:44:50
Message-ID: E1acGG2-0001u2-Rb@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
------
REL9_4_STABLE

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

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

Browse pgsql-committers by date

  From Date Subject
Next Message Joe Conway 2016-03-05 19:11:09 pgsql: Expose control file data via SQL accessible functions.
Previous Message Fujii Masao 2016-03-05 17:44:38 pgsql: Ignore recovery_min_apply_delay until recovery has reached consi