Re: adding 'zstd' as a compression algorithm - Mailing list pgsql-hackers

From Andrey Borodin
Subject Re: adding 'zstd' as a compression algorithm
Date
Msg-id C891A99F-513E-4103-9FB4-9F5A53DD6D32@yandex-team.ru
Whole thread Raw
In response to adding 'zstd' as a compression algorithm  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers

> 15 февр. 2022 г., в 23:20, Robert Haas <robertmhaas@gmail.com> написал(а):
>
> 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"
commitfestentries, 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.


pgsql-hackers by date:

Previous
From: Kyotaro Horiguchi
Date:
Subject: Re: [PATCH] Fix out-of-bouds access (src/common/wchar.c)
Next
From: Amit Kapila
Date:
Subject: Re: row filtering for logical replication