Note
This parameter was introduced in OceanBase Database V4.3.2.
Description
storage_rowsets_size specifies the maximum number of rows allowed in a batch for vectorized processing in the columnstore engine.
Limitations
Query the parameter
In the
systenant or a user tenant, you can execute theSHOW PARAMETERSstatement to query the parameter or query theGV$OB_PARAMETERSview for the parameter.Modify the parameter
You can modify the parameter in the
systenant or a user tenant.
Attributes
| Attribute | Description |
|---|---|
| Type | Integer |
| Default value | 8192 |
| Value range | (0, 1048576] |
| 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. |
Considerations
This parameter takes effect only for the columnstore engine. You can modify this parameter based on the number of rows in microblocks to improve execution efficiency of the columnstore engine.
Examples
Set the maximum number of rows allowed in a batch for vectorized processing in the columnstore engine to 16384.
obclient> ALTER SYSTEM SET storage_rowsets_size=16384;