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 | |
| Effective upon OBServer node restart | No |
| Modifiable | Yes. You can use the ALTER SYSTEM SET statement to modify the parameter. |
Considerations
Due to the potential for inconsistent compression results when using different minor versions of the zlib compression algorithm on the same data, OceanBase Database no longer supports the zlib_1.0 compression algorithm starting from V4.2.2. This change aims to prevent potential issues with recovering replica data during the database upgrade process.
Examples
obclient> ALTER SYSTEM SET default_compress_func = 'lz4_1.0';