Used the vector extension for similarity storage and ranking, with a cosine index and distance ordering plus filtering of missing embeddings. Migration SQL was written but never applied to a live database in this task.
- What worked
- Simple column plus index design covered storage and top-N similarity ranking at the current scale.
