Re: A Question about FPW and WAL

Ok, thanks.

On Mon, 3 Apr 2023 at 22:30, Rui DeSousa <rui(at)crazybean(dot)net> wrote:

>
>
> On Apr 3, 2023, at 5:38 AM, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> wrote:
>
> By default, index full-page write is disabled. If the index is broken, you
> can
> rebuild the index to solve it. Although the security of index data cannot
> be
> guaranteed, this setting can greatly reduce the problem of storage space
> explosion
> caused by wal write amplification.
>
>
> I would feel funny about a parameter like that.
>
>
> I agree. To allow for indexes to become corrupt by design would be a bad
> idea. Rebuilding indexes is a not a solution as some index rebuilds takes
> hours on very large tables. Dealing with identifying corrupted indexes and
> the issues caused by them would be a nightmare to deal with and not very
> ACID compliant.
>