Hi, @malek shabou Welcome to the Microsoft Q&A platform, thanks for posting the question
Yes, LZ4 Compression is not supported, currently, we do not have any ETA by when it is supported.
Please let me know if you have any additional questions or facing any issues.
Regards
Geetha
Hi,
i get an error when i try to change the default compression
ALTER SYSTEM SET default_toast_compression='lz4';
ERROR: invalid value for parameter "default_toast_compression": "lz4"
HINT: Available values: pglz
and default_toast_compression is not present on the azure portal (server parameters)
Regards,
as if the postgresql was not build with "--with-lz4"
i have an error when i try to change the compression
ALTER SYSTEM SET default_toast_compression='lz4'; ERROR: invalid value for parameter "default_toast_compression": "lz4" HINT: Available values: pglz
as if the PG14 was not build with --with-lz4
i have an error when i try to change the compression:
ALTER SYSTEM SET default_toast_compression='lz4';
ERROR: invalid value for parameter "default_toast_compression": "lz4"
HINT: Available values: pglz
and the default_toast_compression don't exist in the server parameter (azure portal)
best regards,
@malek shabou Can you please share what is your use case and what you are trying to achieve?
Regards
Geetha
Hi,
i want to compress some column with lz4.
cf:
create table testcompressionlz4 (a text compression lz4);
PGSQL return an error:
ERROR: compression method lz4 not supported
DETAIL: This functionality requires the server to be build with lz4 support.
HINT: Youn need to rebuild PostgreSQL using --with-lz4
SQL state: 0A000
Regards,
Malek,
@malek shabou let me repro this and provide you with more details
Regards
Geetha
@malek shabou apologies for the inconvenience after repro I got to know that this is not supported. I have updated my comments above, I will check with the internal product team on the reason for not supporting this feature.
Regards
Geetha
Sign in to comment