Quote:
Originally Posted by kovidgoyal
FTS databases typically see very little churn because you dont often re-index or delete or update books, so vacuuming is relatively less useful. Especially so soon after it is created, but the vacuum function should be available and I have now made it so.
|
The main one I can think of is someone splitting up a library into several smaller ones, which would remove a
lot of index entries from the original. But that probably wouldn't be very common.
Just curious: Any idea how does re-indexing work when updating a fanfic with new chapters? I'd assume that the marked-as-unused space just immediately gets reclaimed by the new index coming in.