Data Compression in OLTP Scenarios
Availability
This feature is available since openGauss 3.0.0.
Introduction
Row-store data compression is supported in OLTP scenarios and general compression algorithms are provided. Data pages are transparently compressed and page storage address files are added to achieve high compression and high performance.
Benefits
Typically, this feature is applicable where the database disk space needs to be reduced.
Description
Data compression in OLTP scenarios can reduce the disk space usage of row-store tables and index data and improve performance in I/O-intensive database systems.
Constraints
Only row-store tables and B-tree indexes are supported. This feature cannot be used in the Ustore and segment-page storage engines.
Compressed table index files are accessed using memory-mapped (mmap). max_map_count must be set properly based on the number of compressed table files.