Re: WAL compression setting after PostgreSQL LZ4 default change

[Tomas Vondra]

On 8/7/26 10:34, Andrey Borodin wrote:
> Tomas, thanks for benchmarks! I agree that x2 WAL reduction actually makes 
> Zstd
> a good default when wal_compression = on.
> 
>> On 7 Aug 2026, at 13:23, Tomas Vondra <to...@vondra.me> wrote:
>>
>> 8.25%  postgres  libzstd.so.1.5.7  [.] ZSTD_createDCtx_internal
> 
> (sorry for offtopic)
> 
> That's an interesting profile.
> Along with published patch to retain compression context we can also
> retain decompression context. But that's for PG20 anyway.
> 

Right, there may be a way to make the zstd decompression cheaper. But
it's too late for PG19.


regards

-- 
Tomas Vondra