Re: WAL compression setting after PostgreSQL LZ4 default change - Mailing list pgsql-hackers

From wenhui qiu
Subject Re: WAL compression setting after PostgreSQL LZ4 default change
Date
Msg-id CAGjGUA+ERbxcGzfiKDT2LpqU095E5=E2BvqCWXMTKgm-jns14Q@mail.gmail.com
Whole thread
In response to Re: WAL compression setting after PostgreSQL LZ4 default change  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-hackers
HI 


> A few releases later, where I know that many deployments are using
> either lz4 or zstd and nobody has complained back, I see a much better
> argument in changing the behavior of "on" to mean "zstd" -> "lz4" ->
> "pglz" in order of priority, based on how efficient these algorithms
> are known to be.

V2 path  does exactly that.
 
> It would be compelling to make this change for v19, so that it is in line
> with the change for "default_toast_compression".  But I guess it is too late
> in the cycle for that.
 
The feature was frozen in April. It won't be too late to include it in Version 20—better late than never.



Thanks  

pgsql-hackers by date:

Previous
From: lakshmi
Date:
Subject: Re: let ALTER TABLE DROP COLUMN drop whole-row referenced object
Next
From: vignesh C
Date:
Subject: Re: sequencesync worker race with REFRESH SEQUENCES