Help Center/
GaussDB/
Feature Guide(Centralized_V2.0-8.x)/
Storage Engine/
Data Lifecycle Management: OLTP Table Compression/
Restrictions
Updated on 2025-05-29 GMT+08:00
Restrictions
- System catalogs, MOTs, global temporary tables, local temporary tables, sequence tables, Ustore segment-page tables, unlogged tables, and compressed TOAST data are not supported.
- User can set ILM policies for ordinary tables, partitions, and level-2 partitions.
- Astore/Ustore user tables of ordinary tables, partitions, and level-2 partitions are supported.
- This feature is valid only in A-compatible, PG-compatible, or B-compatible mode.
- Ustore does not support encoding and decoding, thus offering a compression ratio lower than Astore.
- The partial decompression feature is added to the current version. As a result, some small tables are not compressed because their compression gain does not meet requirements. However, they can be compressed in earlier versions without the partial decompression feature. For example, a table containing only one column of the int1 type cannot be compressed since the current version.
Parent topic: Data Lifecycle Management: OLTP Table Compression
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
The system is busy. Please try again later.
For any further questions, feel free to contact us through the chatbot.
Chatbot