Help Center/ GaussDB(DWS)/ Developer Guide/ Standard Data Warehouse (9.1.0.x)/ GUC Parameters of the GaussDB(DWS) Database/ Resource Consumption/ Kernel Resources
Updated on 2025-03-04 GMT+08:00
View PDF
Share

Kernel Resources

This section describes kernel resource parameters. Whether these parameters take effect depends on OS settings.

max_files_per_node

Parameter description: Specifies the maximum number of files that can be opened by a single SQL statement on a single node. Generally, you do not need to set this parameter.

Type: SUSET

Value range: an integer ranging from –1 to INT_MAX. The value –1 indicates that the maximum number is limited.

Default value: 50000

  • For a newly installed cluster of 9.1.0 or later, the default value of this parameter is 50000.
  • In an upgrade scenario, if the original cluster supports the max_files_per_node parameter, the default value of this parameter remains the same for forward compatibility.
  • In the upgrade scenario, if the original cluster does not support the max_files_per_node parameter, the default value of this parameter is –1 after the upgrade.
  • If error message "The last file name is [%s] and %d files have already been opened on data node [%s] with a maximum of %d files." is displayed during statement execution, increase the value of max_files_per_node.
Parent topic: Resource Consumption