Similarity ordering for operators about pgvector HOT 3 CLOSED

The 2nd and 3rd operations - both representing "further distance from a query vector" or "furthest neighbors," are currently not supported as indexable operations. Currently the main focus for ANN indexing methods focus on nearest neighbors, not furthest neighbors.

Is there a particular use case you're trying to solve with looking for furthest neighbors? How large is the dataset that you're using, and how big are the vectors?

from pgvector.

Thank you for the quick answer. I was comparing the quality of results of different approaches with the goal to implement a similarity search. Vectors are 768-dimensional, and there are approx. half a million of them.

What's puzzling me is that just using order by vec <#> '[1,2,3'] (and similarly for <=>) appears to work - they do produce results which looks like "similar" vectors when converted back to text. Am I wrong to interpret the concept of "furthest neighbors" to just "inverse distance ordering" (i.e. to convert furthest neighbors to nearest neighbours, just add "ORDER BY...DESC")?

from pgvector.

Hi @ivoras, to get the nearest neighbors, you should order by just the operator (in ascending order, which is the default).

ORDER BY vec <-> '[1,2,3]'
ORDER BY vec <#> '[1,2,3]'
ORDER BY vec <=> '[1,2,3]'

from pgvector.