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
Opened by Daniel Jewell (danieljewell) - Monday, 11 July 2022, 03:52 GMT
Last edited by freswa (frederik) - Thursday, 09 February 2023, 17:47 GMT
|
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
Thursday, 09 February 2023, 17:47 GMT
Reason for closing: Fixed
Additional comments about closing: postgresql-15.1-3
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