wal_compression

Поиск
Список
Период
Сортировка
От Fabrice Chapuis
Тема wal_compression
Дата
Msg-id CAA5-nLDKRC6PojoRs6saYuGzanAK60r5OT4paMpALKJCuVn61w@mail.gmail.com
обсуждение исходный текст
Ответы Re: wal_compression
Список pgsql-admin
In Postgres 17 doc, for wal_compression parameter it's written:
"Turning this parameter on can reduce the WAL volume without increasing the risk of unrecoverable data corruption"
If 
wal_compression = on then when a full page is written in the wal, it will be compressed. What I do not understand is that the wal file keeps the same size 16Mb. What is the interest to activate wal_compression?

Thanks in advance for explanation

Fabrice

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