On 19 December 2013 19:33, Simon Riggs <[email protected]> wrote:
> On 19 December 2013 19:19, Thom Brown <[email protected]> wrote: > > On 12 December 2013 10:56, Simon Riggs <[email protected]> wrote: > >> Allow time delayed standbys and recovery > >> > >> Set min_recovery_apply_delay to force a delay in recovery apply for > commit and > >> restore point WAL records. Other records are replayed immediately. > Delay is > >> measured between WAL record time and local standby time. > >> > >> Robert Haas, FabrÃzio de Royes Mello and Simon Riggs > >> Detailed review by Mitsumasa Kondo > > > > Could a note be added about the additional disk space requirements for > > WAL on the standby? If one is delaying replay, WAL files created over > > the delayed period will build up in pg_xlog on the standby until > > they're consumed upon replay, so considerations about storing those > > additional files will need to be made. It may otherwise trip up > > anyone who, say, delays replay by 24 hours in a busy production > > environment, and finds they have run out of disk space and no longer > > have a valid standby. > > Thanks Thom, good point. I will add a note to the docs. > Just a reminder that this note hasn't been added to the docs yet. -- Thom
