News for hackers. Stuff that matters.
Re:Find anything fast with Google's vector search technology by eob on Tuesday December 14, 2021 @01:53PM (#29555697)
My 2022 wish list is a Postgres plugin that adds vector + AKNN support that plays well with relational queries. There are so many use cases of that.

I believe Ant Financial has published an open source one but iirc the English language documentation is sparse.

Re:Find anything fast with Google's vector search technology by akane on Tuesday December 14, 2021 @03:58PM (#29557608)
Check out pgvector: https://github.com/ankane/pgvector (disclosure: am author)

It uses IVFFlat indexing, but could be extended to support product quantization / ScaNN.

Re:Find anything fast with Google's vector search technology by ccleve on Tuesday December 14, 2021 @03:37PM (#29557266)
Do you have a link? I'd like to see it.

I googled and did not find much pertaining to "ant financial" and "postgres". Perhaps your google-fu is better than mine...

Re:Find anything fast with Google's vector search technology by etiennedi on Tuesday December 14, 2021 @03:57PM (#29557586)
Checkout the open source vector search engine Weaviate: https://github.com/semi-technologies/weaviate

It’s not a relational db, but it supports Graph-like connections between objects, which makes it really easy to model your relations.

Re:Find anything fast with Google's vector search technology by thirdtrigger on Tuesday December 14, 2021 @04:04PM (#29557722)
Jup – this is an example from the demo dataset in the docs: https://link.semi.technology/3DPcphe