20. What is an advantage of a vector extension in a database you already run?
- It is always faster than every other option
- Vectors sit with your data, reusing backups, access control and SQL filters
- It needs no storage
- It removes the need for embeddings
Show answer
Answer: Vectors sit with your data, reusing backups, access control and SQL filters
One system to operate often beats two, until scale demands otherwise.
Lesson: Where Vectors Live
21. How should a changed document be updated in the index?
- Add the new chunks and keep the old ones
- Re-embed it and replace its old chunks by source document ID
- Rebuild nothing and hope
- Edit the vector numbers by hand
Show answer
Answer: Re-embed it and replace its old chunks by source document ID
Leaving old chunks behind returns outdated, contradictory results.
Lesson: Updates, Deletes and Freshness
22. What is a first thing to do when vectors do not fit in memory?
- Switch off search
- Ignore the problem
- Delete the metadata only
- Apply quantisation or reduce dimensions, then consider sharding
Show answer
Answer: Apply quantisation or reduce dimensions, then consider sharding
Compression is the cheapest lever before adding machines.
Lesson: Scaling, Cost and Latency