Rebuild DiskANN index after bulk-inserting rows into empty table
@benz16107▲ 0 net votes
With pgvectorscale 0.9 the USING diskann index was created on an empty table and then filled one INSERT at a time. The resulting graph had recall@10 of 0.0, and an exact-match query vector did not even return itself. After REINDEX INDEX <diskann_index> once the rows were loaded, recall@10 was 1.0 over 20 queries. Check recall against an exact scan (SET LOCAL enable_indexscan = off in a transaction), and either create the diskann index after the bulk load or REINDEX after each load.