Note
For V4.x, this parameter is removed starting with V4.2.0.
Description
max_px_worker_count specifies the maximum number of threads that can be used for SQL parallel query engines.
Attributes
| Attribute | Description |
|---|---|
| Type | Int |
| Default value | 64 |
| Value range | [0, 65535] |
| 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
Set the maximum number of threads that can be used for SQL parallel query engines to 64.
obclient> ALTER SYSTEM SET max_px_worker_count=64;