lz4 compression

malek shabou 0

Hello,

postgresql 14 add the support of lz4 compression of the toast. (https://www.postgresql.fastware.com/blog/what-is-the-new-lz4-toast-compression-in-postgresql-14)

but the version 14 of the postgresql flexible server on azure don't support it. have you any ETA for the support of the LZ4 ?

thank's

2 answers

GeethaThatipatri-MSFT 27,337 Reputation points Microsoft Employee

2023-03-01T13:40:14.82+00:00

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
Please sign in to rate this answer.
malek shabou 0 Reputation points

2023-03-01T21:29:32.02+00:00

Hi,

yes i two issues:

the parameter default_toast_compression is not present in flexible server parameter (on the azure portal)

ALTER SYSTEM SET default_toast_compression='lz4'; return and error:
ERROR: invalid value for parameter "default_toast_compression": "lz4" HINT: Available values: pglz

the flexible server is runing PG14

Regards,

malek,

malek shabou 0 Reputation points

2023-03-01T21:40:09.5266667+00:00

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,

malek shabou 0 Reputation points

2023-03-01T21:44:56.69+00:00

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

malek shabou 0 Reputation points

2023-03-01T21:47:57.0933333+00:00

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,

GeethaThatipatri-MSFT 27,337 Reputation points Microsoft Employee

2023-03-01T22:03:36.9333333+00:00

@malek shabou Can you please share what is your use case and what you are trying to achieve?

Regards

Geetha

malek shabou 0 Reputation points

2023-03-01T23:43:19.8266667+00:00

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,

GeethaThatipatri-MSFT 27,337 Reputation points Microsoft Employee

2023-03-02T19:24:34.9066667+00:00

@malek shabou let me repro this and provide you with more details

Regards

Geetha

GeethaThatipatri-MSFT 27,337 Reputation points Microsoft Employee

2023-03-03T15:07:44.3+00:00

@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
Deleted

This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

Comments have been turned off. Learn more