Subject: Re: adding 'zstd' as a compression algorithm

From: Andrey Borodin <[email-masked]>
Date: Thu, 17 Feb 2022 11:12:50 +0500

> 15 февр. 2022 г., в 23:20, Robert Haas <[email-masked]> написал(а):
> 
> Anyway, those are my thoughts. What are yours?

+1 for adding Zstd everywhere. Quite similar patches are already a part of "libpq compression" and "zstd for pg_dump" commitfest entries, so pushing this will simplify those entries IMV.

Also I like the idea of defaulting FPI compression to lz4 and adding Zstd as wal_compression option.
I don't think Zstd is obvious choice for default FPI compression: there are HW setups when disks are almost as fast as RAM. In this case lz4 can improve performance, while Zstd might make things slower.

Thanks!

Best regards, Andrey Borodin.