Note
-
For OceanBase Database V4.3.5, this parameter is available starting with BP3.
Description
load_vector_index_on_follower controls whether the follower role automatically loads in-memory vector indexes. The follower role here includes follower nodes in the primary cluster as well as both leader and follower nodes in the standby cluster. When this parameter is set to false, the above nodes will not automatically load vector indexes into memory. Note that this parameter is not synchronized to the standby cluster. In a primary-standby cluster setup, both the primary and standby clusters need to be configured separately.
Privilege requirements
Query the parameter
The
systenant and all user tenants can use theSHOW PARAMETERSstatement or theGV$OB_PARAMETERSview to query this parameter.Modify the parameter
Both the
systenant and user tenants can modify this parameter.
Attributes
| Attribute | Description |
|---|---|
| Type | Boolean |
| Default value | true |
| Value range | true/false |
| Modifiable | Yes. You can use the ALTER SYSTEM SET statement to modify this parameter. |
| Effective upon OBServer node restart | No. The setting takes effect immediately. |
Examples
Set this parameter to true to enable automatic synchronization of memory vector indexes on the follower nodes.
ALTER SYSTEM SET load_vector_index_on_follower = true;