Spill or workfile configuration parameters

posted May 25, 2015, 9:17 AM by Sachchida Ojha
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.
Comments