Horton

Re: Making WAL archiving faster — multi-file support and async ideas

Greg Sabino Mullane <htamfids@gmail.com>

View thread
From: Greg Sabino Mullane <htamfids@gmail.com>
To: Alyona Vinter <dlaaren8@gmail.com>
Cc: Stepan Neretin <slpmcf@gmail.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2025-08-25T13:38:16Z
Lists: 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

--
Crunchy Data - https://www.crunchydata.com
Enterprise Postgres Software Products & Tech Support