• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. Setting Configuration Parameters
  5. Appendix B: GUC Parameter Description
  6. Resource Consumption
  7. Disk space

Disk space

This section describes the disk space parameter, which is used to set a limit on the disk space for storing temporary files.

temp_file_limit

Parameter description: Sets the maximum amount of disk space that a session uses for temporary files, such as sort and hash temporary files, or cursor temporary files.

This setting constrains the total space used at any instant by all temporary files used by a specific session.

This parameter is a SUSET parameter. Set it based on instructions provided in Table 1.

This parameter does not apply to disk space used for temporary tables during the SQL query process.

Value range: An integer. The unit is KB.

Default value: -1, indicating that no limit is set to the maximum amount of disk space that a session uses for temporary files.