wal_compression

From: Fabrice Chapuis <fabrice636861(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: wal_compression
Date: 2025-01-20 10:22:46
Message-ID: CAA5-nLDKRC6PojoRs6saYuGzanAK60r5OT4paMpALKJCuVn61w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Guillaume Lelarge 2025-01-20 10:31:44 Re: wal_compression
Previous Message Guillaume Lelarge 2025-01-20 09:34:31 Re: Performance issue - Seq Scan