FS#75295 - [postgresql] lz4 should be enabled during build to enable use of new toast compression lz4

Attached to Project: Arch Linux
Opened by Daniel Jewell (danieljewell) - Monday, 11 July 2022, 03:52 GMT
Last edited by freswa (frederik) - Thursday, 09 February 2023, 17:47 GMT
Task Type Feature Request
Category Packages: Extra
Status Closed
Assigned To Levente Polyak (anthraxx)
Architecture All
Severity Medium
Priority Normal
Reported Version
Due in Version Undecided
Due Date Undecided
Percent Complete 100%
Votes 2
Private No

Details

I was genuinely shocked to find that postgres 14+ is not compiled with lz4 support on Arch. (I usually run Postgres on Debian and this was my first time configuring it for Arch - imagine my surprise when the server wouldn't start because I set default_toast_compression='lz4' ... one of those changes I make by habit on all postgres installs.)

Without lz4, it's not possible to use the new (in 14) lz4 toast compression which is much faster and better than the older 'pglz' compression type. Implementing this should just be a "--with-lz4" for configure and making sure that lz4 is installed as a dependency...

Also, fwiw, --with-zstd is new in postgres 15 ... :)
This task depends upon

Closed by  freswa (frederik)
Thursday, 09 February 2023, 17:47 GMT
Reason for closing:  Fixed
Additional comments about closing:  postgresql-15.1-3
Comment by nl6720 (nl6720) - Tuesday, 31 January 2023, 16:22 GMT
postgresql 15.1-1 is in the repos now, but it's built with neither lz4 nor zstd support.

E.g.:

[postgres]$ pg_basebackup -D /tmp/dbdump -F tar -Z lz4
pg_basebackup: error: invalid compression specification: this build does not support compression with LZ4

[postgres]$ pg_basebackup -D /tmp/dbdump -F tar -Z zstd
pg_basebackup: error: invalid compression specification: this build does not support compression with ZSTD

Loading...