Overview
ob_encoding_granularity specifies the maximum number of rows for encoding a single microblock.
Privilege requirements
Query parameters
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 | 65536 |
| Value range | [8192, 1048576] |
| Modifiable | Yes, you can use theALTER SYSTEM SETStatement modification. |
| Whether to restart the OBServer node for the change to take effect | No, the setting takes effect immediately. |
Usage instructions
In scenarios where there are a small number of updates in the AP business, if it is difficult to accelerate filtering using skip index due to a large number of microblock rows, or if major compaction performance is poor because microblocks are difficult to reuse, you can appropriately reduce this parameter to improve performance.
Configuration example
Set the maximum number of rows for single microblock encoding to 8,192.
obclient> ALTER SYSTEM SET ob_encoding_granularity=8192;