Spill or workfile configuration parameters

Post date: May 25, 2015 4:17:53 PM

Greenplum introduced 2 server configuration parameter. 

1. gp_workfile_limit_per_query – This sets the maximum disk size (in kilobytes) an individual query is allowed to use for creating temporary spill files at each segment. 

The default value is 0, which means a limit is not enforced. 

2. gp_workfile_limit_per_segment – Sets the maximum total disk size (in kilobytes) that all running queries are allowed to use for creating temporary spill files at each 

segment. The default value is 0, which means a limit is not enforced.