AnalyticDB for PostgreSQL provides extensive kernel parameter optimizations for vector database scenarios. To use this feature, you must first enable it in the console. This topic describes how to enable or disable vector search engine optimization.
Scenarios
Enable this feature for vector analysis scenarios, such as AI-generated content (AIGC) and vector search.
This feature is not recommended for mainstream analysis, data warehousing, or real-time data warehousing scenarios.
Prerequisites
An AnalyticDB for PostgreSQL instance in elastic storage mode is created.
The engine kernel version meets one of the following requirements:
Version 6.0: V6.3.10.18 or later.
Version 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 do not meet the requirements, upgrade or downgrade the compute nodes.
Usage notes
Enabling vector search engine optimization consumes a large amount of instance memory and significantly reduces query concurrency. Evaluate the potential impact before you enable this feature.
Enabling or disabling vector search engine optimization restarts the instance. The instance is unavailable during the restart. 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, click Enable Optimization to the right of Vector Search Engine Optimization.
In the dialog box that appears, click OK.
To disable the feature, click Disable Optimization to the right of Vector Search Engine Optimization.