Re:Supabase Vector, the Open Source Vector Toolkit for Postgres
by AdamProut on Thursday June 08, 2023 @10:37AM
(#36242588)
This may depend on if your use case is only vector search in isolation (ANN lookups). In this scenario PG Vector is potentially not the best option (https://ann-benchmarks.com/)
That said, using PG Vector (or using other SQL databases with vector search support.. many have this capability) will let you do both ANN and your usual SQL filtering and joining (or full text, or.. etc) to produce more hand tuned results to a query. This is something the specialized vector databases don't have much support for.
That said, using PG Vector (or using other SQL databases with vector search support.. many have this capability) will let you do both ANN and your usual SQL filtering and joining (or full text, or.. etc) to produce more hand tuned results to a query. This is something the specialized vector databases don't have much support for.