Enabling Compression

Enabling Compression

You can configure Greenplum Database to use data compression with some
database features and with some utilities.
Compression reduces disk usage and
improves I/O across the system, however, it adds some performance overhead when compressing and
decompressing data.

You can configure support for data compression with these features and utilities. See the
specific feature or utility for information about support for compression.

Workfiles (temporary spill files that are created when executing a query that requires
more memory than it is allocated) can be compressed. See the server configuration
parameter gp_workfile_compression.