Company
Date Published
Author
David Bressler
Word count
1363
Language
English
Hacker News points
None

Summary

CockroachDB has released vector indexing support into preview, enabling customers to combine transactional data with vector data in a single data store without compromising the underlying fundamental promises of distributed SQL. This innovation is achieved through Cockroach-SPANN (C-SPANN), a new distributed vector indexing algorithm that adapts Microsoft's SPANN and SPFresh algorithms to work well with CockroachDB's unique distributed architecture, enabling efficient answer approximate nearest neighbor queries with high accuracy, low latency, and fresh results. C-SPANN supports accuracy, freshness, scalability, latency, resource usage, and build performance, allowing users to create secondary indexes to accelerate searches, retrieve results in the low 10's of milliseconds, and use a fraction of available CPU and memory during index builds. CockroachDB brings vector similarity searches into developer's hands with the full power of SQL, enabling simple filtering, joins, and aggregations in combination with vector queries, and taking full advantage of its key promises around resilience, scale, performance, geo-data placement, and low cost of ownership.