Coverage from every side, on News.ggInternational Edition
Trending now
Similarity Is Not Truth: Comparing vector distance, is_true(), and extract() in Azure AI for PostgreSQL
- Vector search queries often use top-k similarity, assuming the highest-scoring results are true and can serve as factual validation.
- These scores represent distances between vectors (e.g., for cosine distance in PostgreSQL with pgvector), so they should be used to retrieve relevant results—not as a final ranking of truth.
- Azure AI on HorizonDB can call an AI model to generate embeddings for comparison and provides more specific functions, such as is_true() or extract() , for structured responses.
- Objective In this blog post, I'll use the three of them on a small dataset, a table of…
Summary from the original article
