pg vector 0.8.0 cost bug preventing HNSW search. Can we please get system upgrade to 0.8.1 urgently
HNSW search indices will not be used as artificially high cost is being ascribed to search functions
Need version change quickly, have also sent support ticket if filter by this issue. Production system now non functional, urgent
4 Replies
This is user helping user forum and posts are not monitored by Supabase team.
I don't see a 0.8.1 pgvector in their repository...
https://github.com/pgvector/pgvector
And last release was last year.
thanks for link gary, i didnt know that. I tink this cost bug might mean i have to rollback pgvector for use
I don't use this, but I've seen some comment about you can't do certain type of searches/filters with pgvector as the index does not work. That is either here or supabase github discussion. Late for me so not going to search for it. But I believe it causes the HNSW index not work.
all good, thanks for taking the time 👍