Hi, On 2022-02-16 09:58:44 +0900, Michael Paquier wrote: > On Tue, Feb 15, 2022 at 01:42:55PM -0800, Andres Freund wrote: > > I think well before removing stuff we should default to decent compression > > algorithms. E.g. -Z/--compress should probably not continue to use gzip if > > better things are available. > > Which one of lz4 or zstd would it be though? LZ4 is light on CPU, and > compresses less than zstd which is more CPU intensive with more > compression, so the choice does not look that straight-forward to me.
For backups it's pretty obviously zstd imo. At the lower levels it achieves considerably higher compression ratios while still being vastly faster than gzip. Without even using the threaded compression support the library has. For something like wal_compression it'd be a harder question. Greetings, Andres Freund
