Re: A Question about FPW and WAL

Поиск
Список
Период
Сортировка
От Dawn Yu
Тема Re: A Question about FPW and WAL
Дата
Msg-id CALiuKDFRXcE77dm=c1gcsL12_DOw6zXSt-E3hk-wjen0a-7vSw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: A Question about FPW and WAL  (Rui DeSousa <rui@crazybean.net>)
Список pgsql-admin
Ok, thanks. 

On Mon, 3 Apr 2023 at 22:30, Rui DeSousa <rui@crazybean.net> wrote:


On Apr 3, 2023, at 5:38 AM, Laurenz Albe <laurenz.albe@cybertec.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.

В списке pgsql-admin по дате отправления:

Предыдущее
От: Joseph Hammerman
Дата:
Сообщение: s3-fuse and tiered storage
Следующее
От: "James Pang (chaolpan)"
Дата:
Сообщение: attach partition to parent table with default partition accessexclusive