| From: | wenhui qiu <qiuwenhuifx(at)gmail(dot)com> |
|---|---|
| To: | Christoph Berg <myon(at)debian(dot)org>, Jelte Fennema-Nio <postgres(at)jeltef(dot)nl>, Michael Paquier <michael(at)paquier(dot)xyz>, Japin Li <japinli(at)hotmail(dot)com>, Fujii Masao <masao(dot)fujii(at)gmail(dot)com>, wenhui qiu <qiuwenhuifx(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, John Naylor <johncnaylorls(at)gmail(dot)com> |
| Subject: | Re: WAL compression setting after PostgreSQL LZ4 default change |
| Date: | 2026-07-08 06:37:36 |
| Message-ID: | CAGjGUALBMSzJ=ngL0k0CR6MqM+1W=Y+=+MSv+Z4R5jvmr47P5A@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi
> I would like to see "on" to be moved to some better value (likely lz4,
> > like toast compression), and if some day, there is yet a better
> > choice, we should move it again.
> Yes, After PostgreSQL 19, lz4 became a required dependency unless you
> compile it yourself with --without-lz4. In most environments, lz4 is
> already installed, so along this code path the effective choice is
> essentially fixed to lz4.At cluster scale, it would make more sense to
> expose this parameter in the frontend as a boolean setting, rather than
> letting users choose from multiple compression options.
Thanks
| From | Date | Subject | |
|---|---|---|---|
| Next Message | solai v | 2026-07-08 06:52:28 | Re: Proposal: INSERT ... BY NAME |
| Previous Message | Michael Paquier | 2026-07-08 06:29:44 | Re: injection_points: Switch wait/wakeup to use atomics rather than latches |