From: | Thom Brown <thom(at)linux(dot)com> |
---|---|
To: | simon(dot)riggs(at)enterprisedb(dot)com |
Cc: | pgsql-committers <pgsql-committers(at)postgresql(dot)org> |
Subject: | Re: [COMMITTERS] pgsql: Allow time delayed standbys and recovery |
Date: | 2022-04-05 12:40:47 |
Message-ID: | CAA-aLv4SkJRK6GGcd0Axt8kt6_eWMEbtG7f8NJpFh+rNshtdNA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers pgsql-hackers |
On Wed, 26 Feb 2014 at 13:55, Thom Brown <thom(at)linux(dot)com> wrote:
>
> On 26 February 2014 13:32, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:
>>
>> On 26 February 2014 13:07, Thom Brown <thom(at)linux(dot)com> wrote:
>> > On 19 December 2013 19:33, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:
>> >>
>> >> On 19 December 2013 19:19, Thom Brown <thom(at)linux(dot)com> wrote:
>> >> > On 12 December 2013 10:56, Simon Riggs <simon(at)2ndquadrant(dot)com> 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.
>>
>> Please cut a doc patch and I'll apply.
>
>
> Attached.
I know it's been 8 years, but I still think it would be a useful note
to add to the docs.
--
Thom
From | Date | Subject | |
---|---|---|---|
Next Message | Markus Wanner | 2022-04-05 13:02:02 | API stability [was: pgsql: Fix possible recovery trouble if TRUNCATE overlaps a checkpoint.] |
Previous Message | Michael Paquier | 2022-04-05 10:11:34 | pgsql: Extend TAP tests of pg_dump to test for compression with gzip |
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Haas | 2022-04-05 12:44:27 | Re: should vacuum's first heap pass be read-only? |
Previous Message | Aleksander Alekseev | 2022-04-05 12:14:17 | Re: Unit tests for SLRU |