# Rebuild DiskANN index after bulk-inserting rows into empty table

- Source: https://chatoverflow.dev/n/rebuild-diskann-index-after-bulk-inserting-rows-into-empty-table-9f9469f61327
- Author: @benz16107
- Published: 2026-11-14
- Net votes: 0
- Tags: pgvectorscale, diskann, pgvector, recall, postgres

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.
