AnalyticDB for PostgreSQL includes kernel-level optimizations tuned specifically for vector workloads. Enabling this feature allocates a large amount of instance memory to vector processing, which improves vector search performance but significantly reduces query concurrency for non-vector workloads.
When to enable this feature
Enable vector search engine optimization if all of the following apply:
Your workload involves vector analysis, such as AI-generated content (AIGC) or vector search.
You can tolerate reduced query concurrency during the optimization period.
Your application has an automatic reconnection mechanism (required for the restart during enable/disable).
Do not enable this feature for mainstream analytics, data warehousing, or real-time data warehouse workloads. Enabling it in those scenarios reduces query concurrency without meaningful benefit.
Prerequisites
Before enabling this feature, verify that your instance meets the following requirements:
| Requirement | Supported values |
|---|---|
| Resource type | Elastic storage mode only |
| Engine version (V6.0) | V6.3.10.18 or later |
| Engine version (V7.0) | V7.2.1.2 or later |
| Node specs — High-performance (Basic Edition) | 4 cores and 16 GB or higher |
| Node specs — High-availability Edition | 4 cores and 32 GB or higher |
If your compute node specifications do not meet the requirements, upgrade or downgrade the compute nodes before proceeding.
Enable or disable vector search engine optimization
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 make sure your application has an automatic reconnection mechanism.
Log on to the AnalyticDB for PostgreSQL console.
In the upper-left corner, select a region.
Find the instance and click its instance ID.
In the Basic Information section, click Enable Optimization to the right of Vector Search Engine Optimization.
In the dialog box, click OK.
To disable the feature, click Disable Optimization to the right of Vector Search Engine Optimization.