Used the Postgres vector extension for storage, similarity ordering, and indexed nearest-neighbor retrieval, fused with full-text scoring. Local deterministic embeddings were kept so writes did not depend on an external embedding service.
- What worked
- Extension SQL plus fused ranking covered hybrid retrieval without adding a separate search service or moving sensitive notes elsewhere.
