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

From Sean O'Grady
Subject Re: Question about wal_compression and what to expect
Date
Msg-id c36c4be478c2b271600a58281711e4add367d136@hey.com
Whole thread Raw
In response to Re: Question about wal_compression and what to expect  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-admin
The internal compression has to compress each record in isolation, which is not nearly as good as compressing the entire file as there are patterns that exist between records not just within records.

I see, that's makes sense. My sense is that wal_compression is really first to alleviate disk IO pressure and secondarily as a space saving benefit. Since I've set about archive_timeout because of a relatively light workload, I probably shouldn't need to worry about IO issues...

Thanks,
Sean

pgsql-admin by date:

Previous
From: Cary Huang
Date:
Subject: Re: SSL cert "not initialized" error with logical replication with 13.11
Next
From: Wells Oliver
Date:
Subject: Poor performance due to parallel seq scan on indexed date field