AnalyticDB for PostgreSQL performs significant engine parameter optimization for vector database scenarios. To use vector search engine optimization, you must enable the feature in the console. This topic describes how to enable or disable vector search engine optimization.
Scenarios
In vector analysis scenarios such as AI-generated content (AIGC) and vector search, we recommend that you enable vector search engine optimization.
In mainstream analysis, data warehousing, and real-time data warehousing scenarios, we recommend that you disable vector search engine optimization.
Prerequisites
An AnalyticDB for PostgreSQL instance in elastic storage mode is created.
The minor version of the instance is 6.3.10.18 or later.
The compute node specifications of the instance are 4 cores and 32 GB or higher. If your instance does not meet the requirement, upgrade node specifications of your instance.
Usage notes
Vector search engine optimization consumes large amounts of memory resources of your instance and significantly decreases the concurrency of queries. Make sure that you have learned the impact before you enable vector search engine optimization.
After you enable or disable vector search engine optimization, your instance restarts. During the restart, your instance is unavailable. We recommend that you perform this operation during off-peak hours and make sure that your application can automatically reconnect to the instance.
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 next to Vector Search Engine Optimization.
In the message that appears, click OK.
To disable vector search engine optimization, click Disable Optimization next to Vector Search Engine Optimization.