On 10/18/21 11:01, Adrian Klaver wrote:
ot sure how much this applies to the Postgres usage of lz4. As I understand it, this is only used internally for table compression. When using pg_dump compression gzip is used. Unless you pipe plain text output through some other program.
This applies when using a 3rd party commercial backup tool with deduplication. You'd be surprised how many people do that. One tool to backup them all, one tool to find them and on the LTO cartridge backup them. I apologize for this cheesy paraphrase of Tolkien, but I couldn't resist. Long story short, for the 3rd party backup tools LZO4 compression will yield better deduplication ratios than other forms of compression, thereby saving you space.
-- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com
