Request a Demo
Home   >   mailing lists

Re: [PATCH] Document wal_compression=on - Mailing list pgsql-hackers

From wenhui qiu
Subject Re: [PATCH] Document wal_compression=on
Date
Msg-id CAGjGUAJr6txwgZ9jC90onH4Gj5OzHHpd0w=B-JYfs+J2kXvL3w@mail.gmail.com
Whole thread
In response to Re: [PATCH] Document wal_compression=on  (Michael Paquier <michael@paquier.xyz>)
List pgsql-hackers
Tree view

Hi 

The recent PostgreSQL commit changes the default TOAST compression to lz4 when LZ4 support is available, based on the rationale that LZ4 is generally more efficient than pglz in terms of CPU usage and compression ratio.Given that, should we also consider changing the default compression method used by wal_compression = on from pglz to lz4?

Currently, wal_compression = on still maps to pglz, while lz4 has to be selected explicitly with:

wal_compression = lz4

If LZ4 is now considered stable and preferable enough to become the default for TOAST compression, it may be worth aligning WAL compression behavior as well, or at least discussing whether on should continue to imply pglz.




Thanks  

pgsql-hackers by date:

Previous
From: Richard Guo
Date:
Subject: Re: Fix HAVING-to-WHERE pushdown with mismatched operator families
Next
From: John Naylor
Date:
Subject: Re: [PATCH] Document wal_compression=on