Overview
storage_rowsets_size specifies the number of rows processed in a vectorized batch by the columnar storage engine.
Privilege requirements
Query parameters
Both the
systenant and all user tenants can query this parameter using theSHOW PARAMETERSstatement or theGV$OB_PARAMETERSview.Modify parameters
Both the
systenant and user tenants can modify this parameter.
Attributes
Attribute |
Description |
|---|---|
| Parameter type | Int |
| Default Value | 8192 |
| Value range | (0,1048576] |
| Modifiable | Yes, you can use the following methods:ALTER SYSTEM SETStatement modification. |
| Whether to restart the OBServer node for the change to take effect | No, the setting takes effect immediately. |
Usage instructions
This parameter takes effect only on the columnar storage engine and specifies the size of a vectorized batch processed by the columnar storage engine at a time. Appropriately adjusting this parameter based on the number of microblock rows can improve the execution efficiency of the columnar storage engine.
Configuration example
Set the columnar storage engine's batch processing size to 16384.
obclient> ALTER SYSTEM SET storage_rowsets_size=16384;