Re: Question about wal_compression and what to expect - Mailing list pgsql-admin

From Scott Ribe
Subject Re: Question about wal_compression and what to expect
Date
Msg-id CDC433EB-E5B0-46CC-AD36-4957419B517C@elevated-dev.com
Whole thread Raw
In response to Re: Question about wal_compression and what to expect  (Sean O'Grady <sean@thingee.com>)
Responses Re: Question about wal_compression and what to expect
List pgsql-admin
> On Jun 21, 2023, at 7:51 AM, Sean O'Grady <sean@thingee.com> wrote:
>
> Yes, my question was essentially do I need to separately compress WAL files for storage/archiving even with
wal_compressionset. So, I think you've answered my question. 

If WAL files use per-page compression internally, you won't get much benefit from compressing them. If they use lz4
internally,then sure, bzip'ing them will get a little benefit, but nowhere near the normal amount. 


pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: SSL cert "not initialized" error with logical replication with 13.11
Next
From: Sean O'Grady
Date:
Subject: Re: Question about wal_compression and what to expect