Acceleration Cluster

show_acce_estimate_detail

Parameter description: When the cluster is accelerated (acceleration_with_compute_pool is set to on), this parameter specifies whether the EXPLAIN statement displays the evaluation information about execution plan pushed down to the accelerated cluster. (Due to specification changes, the current version no longer supports the current feature. Do not use this feature.) The evaluation information is generally used by O&M personnel during maintenance, and it may affect the output display of the EXPLAIN statement. Therefore, this parameter is disabled by default. The evaluation information is displayed only if the verbose option of the EXPLAIN statement is enabled.

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

Value range: Boolean

• on indicates that the evaluation information is displayed in the output of the EXPLAIN statement.

• off indicates that the evaluation information is not displayed in the output of the EXPLAIN statement.

Default value: off

acceleration_with_compute_pool

Parameter description: Specifies whether to use the computing resource pool for acceleration when an OBS is queried. (Due to specification changes, the current version no longer supports the current feature. Do not use this feature.)

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

Value range: Boolean

• on indicates that the query covering OBS is accelerated based on the cost when the computing resource pool is available.
• off indicates that no query is accelerated using the computing resource pool.

Default value: off

max_resource_package

Parameter description: Specifies the upper limit of the concurrent task threads for accelerating each cluster each DN.

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

Value range: 0 to 2147483647

Default value: 0