PlanetScale engineers reveal how they overcame fundamental limitations of vector indexing for relational databases, enabling efficient similarity searches on datasets larger than RAM while maintaining ACID guarantees. Their hybrid approach combines in-memory HNSW with innovative on-disk structures, solving critical challenges in transactional vector operations.