Pgvector 0.5.0 Feature Highlights and how tos

Is there a reason left to use ivfflat compared to hnsw? I am not that deep in the tech. But if hnsw is much much faster thats a big argument. Is hnsw better in every aspect or is the recall accurracy better for ivfflat?

The constant stream of features getting added to pgvector is impressive. Also, really love some of the benchmarks and explanations that were thrown in here.

Just out of curiosity, is it possible to efficiently get "For all rows in table A, give me the two nearest neighbors in table B" in SQL?

Congratulations, can anyone give an insight on how this compares to pg_embedding [0] (Postgres and use HNSW). Or the use-cases compared to other victor databases. It’s getting hard to keep up what’s happening in the LLM scene.<p>[0] <a href="https:&#x2F;&#x2F;github.com&#x2F;neondatabase&#x2F;pg_embedding">https:&#x2F;&#x2F;github.com&#x2F;neondatabase&#x2F;pg_embedding</a>