An HNSW index build on 5 million vectors is extremely slow. Which server parameter most improves build time?
- A work_mem
- B maintenance_work_mem (correct answer)
- C max_connections
- D effective_cache_size
Shortcut: Index construction uses maintenance_work_mem. Raising it (and max_parallel_maintenance_workers) lets more of the graph be built in memory, substantially reducing build time.