This document explains different options that you can use to maintain vector indexes. You might want to maintain indexes to ensure that your indexes adapt to the changes in data that might impact accuracy of your search results. As your dataset grows, use the strategies in the following sections to avoid degradation in query performance.
View vector index metrics
If your table is prone to frequent updates or insertions, then we recommend periodically reindexing the existing ScaNN index in order to improve the recall accuracy for your index. You can monitor index metrics to view changes in vector distributions or vector mutations since the index was built, and then reindex accordingly.
For more information about metrics, see View Vector index metrics.
Manually rebuild your index
You can manually rebuild your index if you want to rebuild it with the configurations you specified when it was created.
To manually rebuild your index, run the following command:
REINDEX INDEX CONCURRENTLY INDEX_NAME;
Replace INDEX_NAME with the name of the index you want to
rebuild—for example, my-scann-index. The index names are shared
across your database. Ensure that each index name is unique to each
table in your database.
For more information about reindexing in PostgreSQL, see REINDEX.