• Fujii Masao's avatar
    Ignore recovery_min_apply_delay until recovery has reached consistent state · d34794f7
    Fujii Masao authored
    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
    d34794f7
recovery-config.sgml 20.9 KB