public inbox for [email protected]  

help / color / mirror / Atom feed

From: Fabrice Chapuis <[email protected]>
To: [email protected]
Subject: wal_compression
Date: Mon, 20 Jan 2025 11:22:46 +0100
Message-ID: <CAA5-nLDKRC6PojoRs6saYuGzanAK60r5OT4paMpALKJCuVn61w@mail.gmail.com> (raw)

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

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: wal_compression
  In-Reply-To: <CAA5-nLDKRC6PojoRs6saYuGzanAK60r5OT4paMpALKJCuVn61w@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox