AnalyticDB for PostgreSQL provides extensive kernel parameter optimizations for vector database scenarios. You must enable this feature in the console before you can use vector search engine optimization. This topic describes how to enable or disable vector search engine optimization.
Scenarios
-
If your instance is used for vector analysis, such as AIGC and vector search scenarios, we recommend that you enable vector search engine optimization.
-
If your instance is used for mainstream analysis, data warehousing, or real-time data warehousing scenarios, we do not recommend that you enable vector search engine optimization.
Prerequisites
-
The instance is of the elastic storage mode.
-
The engine kernel version meets one of the following requirements:
-
V6.0: V6.3.10.18 or later.
-
V7.0: V7.2.1.2 or later.
-
-
The compute node specifications meet the following requirements:
-
High-performance (Basic Edition): 4 cores and 16 GB or higher.
-
High-availability Edition: 4 cores and 32 GB or higher.
NoteIf the specifications do not meet the requirements, you can change the specifications of compute nodes.
-
Usage notes
Enabling vector search engine optimization consumes a large amount of instance memory and significantly reduces instance concurrency. Evaluate the impact before you enable this feature.
Enabling or disabling vector search engine optimization causes the instance to restart. The instance is unavailable during the restart. We recommend that you perform this operation during off-peak hours and make sure that your application has a reconnection mechanism.
Procedure
- Log on to the AnalyticDB for PostgreSQL console.
- In the upper-left corner of the console, select a region.
- Find the instance that you want to manage and click the instance ID.
-
In the Basic Information section, click Enable Optimization on the right side of Vector Search Engine Optimization.
-
In the dialog box that appears, click OK.
To disable this feature, click Disable Optimization on the right side of Vector Search Engine Optimization.