A newer version of this documentation is available. Click here to view the most up-to-date release of the Greenplum 4.x documentation.


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