How Vector Search Actually Works: pgvector, LSH, HNSW, and Semantic Caching Under the Hood

From brute force failure to sub-100ms retrieval across 10 million vectors, a ground-up explanation of every layer.