> Based on this, I agree with the original suggestion to default to > zstd > lz4 > pglz > I don't think we need to "tune" the compression levels for either of the > algorithms. The defaults seem pretty reasonable.
Thank you for your test , It looks like Michael Paquier's suggestion was right—zstd doesn't have much difference in CPU consumption at default compression levels, and it achieves a higher compression ratio. On another note, I recall there was a patch discussing zstd compression for TOAST, but it hasn't been active for a long time. Since zstd offers a higher compression ratio, I think it's worth pushing this forward.
