Database Insights

Add vector similarity search to PostgreSQL with pgvector. Covers HNSW and IVFFlat indexes, cosine similarity queries, OpenAI embedding integration, and hybrid search.

pgvector 0.8 delivers significant HNSW indexing improvements and new distance functions. Here is what changed and how to take advantage of it in production.