Disk Space
This section describes the disk space parameter, which is used to set a limit on the disk space for storing files flushed to the disk.
sql_use_spacelimit
Parameter description: Specifies the space size for files to be flushed to disks when a single SQL statement is executed on a single DN. The managed space includes the space occupied by ordinary tables, temporary tables, and intermediate result sets to be flushed to disks.
Type: USERSET
Value range: an integer ranging from -1 to INT_MAX. The unit is KB. –1 indicates no limit.
Default value: –1
temp_file_limit
Parameter description: Specifies the size of a single file spilled to disk if splitting is triggered in a session. The temporary file can be the one used by sorting or hash tables, or cursors in a session.
This is a session-level setting.
Type: SUSET
Value range: an integer ranging from -1 to INT_MAX. The unit is KB. –1 indicates no limit.
Default value: –1
This parameter does not apply to disk space occupied by temporary tablespaces used for executing SQL queries.
Last Article: Resource Consumption
Next Article: Cost-based Vacuum Delay
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.