Hacker News Reader

Check out pgvector: https://github.com/ankane/pgvector (disclosure: am author)

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

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...

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.

Jup – this is an example from the demo dataset in the docs: https://link.semi.technology/3DPcphe