Enable or disable vector search engine optimization
AnalyticDB for PostgreSQL provides extensive kernel-level optimizations for vector database scenarios. To use vector search engine optimization, you must first enable this feature in the console. This topic describes how to enable or disable the optimization.
Use cases
-
Enable vector search engine optimization if your instance is used for vector analytics, such as AIGC and vector search.
-
Do not enable vector search engine optimization if your instance is used for mainstream analytics, data warehousing, or real-time data warehouse workloads.
Prerequisites
-
The instance runs in elastic storage mode.
-
The engine kernel version meets either of the following requirements:
-
6.0: V6.3.10.18 or later.
-
7.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 are insufficient, change the specifications of compute nodes.
-
Important notes
Enabling vector search engine optimization consumes a significant amount of the instance's memory resources and can sharply decrease concurrency. Before you enable this feature, be aware of these impacts.
Enabling or disabling vector search engine optimization triggers an instance restart, during which the instance is unavailable. Perform this operation during off-peak hours and ensure your application has an automatic 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, to the right of Vector Search Engine Optimization, click Enable Optimization.
-
In the dialog box that appears, click OK.
To disable the feature, click Disable Optimization to the right of Vector Search Engine Optimization.