Help Center/ GaussDB/ Feature Guide(Distributed_8.x)/ Storage Engine/ Data Lifecycle Management: OLTP Table Compression/ Feature Constraints
Updated on 2024-06-07 GMT+08:00
View PDF
Share

Feature Constraints

  • System catalogs, memory tables, global temporary tables, local temporary tables, and sequence tables are not supported.
  • This is valid only in ORA compatibility mode and PG mode.
  • The Ustore does not support encoding and decoding, and the compression ratio is less than 2:1.
  • When compression is enabled for ordinary tables, the space reserved for scale-out must be evaluated based on the size after decompression.
  • Hash bucket tables do not support DBE_HEAT_MAP.ROW_HEAT_MAP and DBE_COMPRESSION.GET_COMPRESSION_TYPE.
  • Compression scheduling is not supported during scale-out.

  • Before scale-out, check whether a compression task is being executed. If yes, wait until the compression task is complete, or run DBE_ILM.STOP_ILM or DBE_ILM_ADMIN.DISABLE_ILM to stop the compression task. After the scale-out is complete, run DBE_ILM_ADMIN.ENABLE_ILM to enable it.