You can do this with a lateral join. SELECT \* FROM A, LATERAL (SELECT \* FROM B... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		winslett on Aug 30, 2023 \| parent \| context \| favorite \| on: Pgvector 0.5.0 Feature Highlights and how tos You can do this with a lateral join. SELECT * FROM A, LATERAL (SELECT * FROM B ORDER BY a.embedding <-> b.embedding LIMIT 2) AS closest_in_b ORDER BY A.id; It’s going to have so-so performance. So, don’t hose your production server. Create a vector index on b.embedding. HNSW will be nice for this use case.

chpatrick on Aug 30, 2023 [–]

Thanks! I've implemented this manually with HNSW and I was wondering if pgvector would be an easy replacement.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact