gp_appendonly_compaction_threshhold
Specifies the threshold ratio (as a percentage) of hidden rows to total rows that triggers compaction of the segment file when VACUUM is run without the FULL option (a lazy vacuum). If the ratio of hidden rows in a segment file on a segment is less than this threshold, the segment file is not compacted, and a log message is issued.
Value Range | Default | Set Classifications |
---|---|---|
integer (%) | 10 | master session reload |