Re: Making WAL archiving faster — multi-file support and async ideas - Mailing list pgsql-hackers

From Greg Sabino Mullane
Subject Re: Making WAL archiving faster — multi-file support and async ideas
Date
Msg-id CAKAnmmKQwS1U9JfOVKaeGsL3fyMftr_qQgu4-rkmAaFwAJKaRg@mail.gmail.com
Whole thread Raw
In response to Re: Making WAL archiving faster — multi-file support and async ideas  (Alyona Vinter <dlaaren8@gmail.com>)
List pgsql-hackers
On Mon, Aug 25, 2025 at 4:31 AM Alyona Vinter <dlaaren8@gmail.com> wrote:
... could attempt a restore using the incomplete archive. While we hope this would cause a clear error during recovery, there is a risk that partial application of non-sequential segments might lead to silent corruption or other unforeseen issues.

Can you expand on how that could happen? Postgres knows the name of the next WAL to look for, so it's not going to ever jump over a missing file.

Cheers,
Greg

--
Enterprise Postgres Software Products & Tech Support

pgsql-hackers by date:

Previous
From: Greg Sabino Mullane
Date:
Subject: Re: [PATCH] Generate random dates/times in a specified range
Next
From: Andrei Lepikhov
Date:
Subject: Re: [BUG] Remove self joins causes 'variable not found in subplan target lists' error