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.