Note
This parameter is available starting with V2.2.50.
Description
px_task_size specifies the amount of data processed by each task of the SQL parallel query engine. You must specify the unit when you configure this parameter.
Privilege requirements
Query the parameter
systenant and all user tenants can query this parameter by using theSHOW PARAMETERSstatement or theGV$OB_PARAMETERSview.Modify the parameter
Only the
systenant can modify this parameter. User tenants cannot modify this parameter.
Attributes
| Attribute | Description |
|---|---|
| Type | Capacity |
| Default value | 2M |
| Value range | [1K, +∞)
NoteStarting from V4.3.5, the minimum value of this parameter is 1K. |
| Modifiable | Yes. You can use the ALTER SYSTEM SET statement to modify the parameter. |
| Effective upon OBServer node restart | No. The setting takes effect immediately. |
Examples
Run the following command to set the amount of data processed by each task of the SQL parallel query engine to 4K:
obclient> ALTER SYSTEM SET px_task_size='4k';