gp_workfile_compress_algorithm

gp_workfile_compress_algorithm

When a hash aggregation or hash join operation spills to disk during query processing,
specifies the compression algorithm to use on the spill files. If using zlib, it must be
in your $PATH on all segments.

If your Greenplum database installation uses serial ATA (SATA) disk drives, setting the
value of this parameter to zlib might help to avoid overloading the disk
subsystem with IO operations.