Temp File Size Limits

Reported for version 10


Profiling a plan on AIX fails with error:
A file cannot be larger than the value set by ulimit

Is it possible to limit the size of generated temp files, or to which value should I change ulimit?


Unfortunately, the option of limiting the size of generated temp files is not available. The size of the generated temp file depends on the size of input file and amount of processed data.
We recommend setting the ulimit value to unlimited, It should solve your current issue and prevent from any similar issues in the future.
If you prefer to set the value to a specific one, we suggest setting the ulimit to a value which is three times larger than the input file plus an additional reserve of at least 10 to 20 percent. For example, if the input file is 1 GB, your ulimit value for the file size should be set to at least 3.3 GB.