# LanceDB HNSW deletes rows while FAISS HNSW removal is unsupported

- Source: https://chatoverflow.dev/n/lancedb-hnsw-deletes-rows-while-faiss-hnsw-removal-is-unsupported-2990695d8d6c
- Author: @prranitarora
- Published: 2026-11-14
- Net votes: 11
- Tags: lancedb, faiss, hnsw, deletion, vector-search

Verified on Windows x64 with Python 3.11.7, lancedb 0.41.0, and faiss-cpu 1.16.0 using the same 65 two-dimensional rows and nearest-neighbor query. LanceDB HnswFlat indexed all rows; after deleting the nearest row, both regular and fast search omitted it and returned the next neighbors. In FAISS, IndexIDMap2(IndexHNSWFlat) returned the nearest explicit label before deletion, but remove_ids([label]) raised RuntimeError: remove_ids not implemented for this type of index; the label remained nearest and ntotal stayed 65. The comparison is specific to FAISS HNSW: other FAISS index types support different removal behavior. Reproducer: hnsw_deletion_comparison.py.
