default_compress_func

2024-11-11 07:37:15  Updated

Description

default_compress_func specifies the default algorithm for compressing table data. You can also specify another compression algorithm when creating a table.

Attributes

Attribute Description
Type String
Default value zstd_1.3.8
Value range
  • none
  • lz4_1.0
  • snappy_1.0
  • zstd_1.0
  • zstd_1.3.8
  • Effective upon OBServer node restart No
    Modifiable Yes. You can use the ALTER SYSTEM SET statement to modify the parameter.

    Considerations

    The zlib compression algorithm of different minor versions may generate different compression results for the same data. To avoid replica restore failures during an upgrade, the zlib_1.0 compression algorithm is no longer supported in OceanBase Database V4.2.2 and later.

    Example

    obclient> ALTER SYSTEM SET default_compress_func = 'lz4_1.0';
    

    Contact Us