storage-fts-rebuilt-on-every-save

IN premise

The `nodes_fts` full-text index is deleted and rebuilt from scratch on each `save()`, guaranteeing consistency with the `nodes` table at the cost of full-reindex overhead.

Summary

Every time the database is saved, the full-text search index is completely torn down and recreated from the current state of the nodes table. This means search results are always perfectly in sync with the actual data, but it also means every save operation pays the cost of reindexing everything, which could become a performance bottleneck as the number of nodes grows.

Details

Sourceentries/2026/04/29/reasons_lib-storage.md