A newer version of this documentation is available. Click here to view the most up-to-date release of the Greenplum 4.x documentation.
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.
|Value Range||Default||Set Classifications|