Troubleshoot vector indexes in the columnar engine

To diagnose index performance or data retrieval issues in the AlloyDB for PostgreSQL columnar engine, you can run SQL verification commands to check the integrity of your vector indexes. Vector indexes use the Approximate Nearest Neighbor (ANN) search strategy to balance query latency and recall. For more information, see Choose a vector index in AlloyDB AI.

Ensure index integrity

To verify that an index in the columnar engine is consistent and doesn't have any corruption or errors, especially when you experience issues related to index performance or data retrieval, use the following SQL command:

  SELECT google_columnar_engine_verify(index => 'INDEX_NAME');

Replace INDEX_NAME with the name of the index.