On Mon, Oct 18, 2021 at 08:01:04AM -0700, Adrian Klaver wrote: > Not 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.
More precisely, LZ4 applies to the compression of toastable values in 14~. In 15~, we can already use it for WAL and the compression of full-page writes. It is worth noting that there are extra patches floating around to add more LZ4 pluggability to pg_dump (I think this has not been published yet), pg_receivewal (published) and base backups through the replication protocol (published). I have seen rather good numbers when it came to WAL, FWIW. Even if the compression ratio was a bit less than pglz, it was much faster. -- Michael
signature.asc
Description: PGP signature
