-
-
Notifications
You must be signed in to change notification settings - Fork 128
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Feature Request: support pgvecto.rs extension #895
Comments
pgvecto.rs isn't a trusted extension. tensorchord/pgvecto.rs#109 |
Yes, that's right. My current understanding is that the restriction for trusted language extensions only applies to custom extensions: supabase/supabase#14235 (comment) What I am asking for is an official integration into the Supabase postgres version. So that you'd be able to activate pgvecto.rs via the dashboard, as with any other extension. |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Hey there!
I hope it's okay that I open an issue for this one.
See: https://github.com/orgs/supabase/discussions/679#discussioncomment-8611842
Supabase currently puts a lot of focus on AI, vectors, RAG, etc. and has published extremely high quality articles like this one that help users (including myself and my company) get the most out of their Supabase vector database in terms of performance and scalability - which is absolutely awesome!
However, pgvector suffers from some serious bottlenecks, like this, which makes it almost unusable in combination with additional filters and indexes without suffering from really bad recall. We are currently experiencing this problem and there seems to be no reasonable workaround for it.
See also: https://github.com/run-llama/llama_index/issues/9519
While searching for possible solutions, we came across pgvecto.rs, which claims to have solved these problems and also works much faster and offers many more features (including compression, support for higher dimensions, lower memory and storage usage and more) than pgvector.
We tested it locally and were surprised at how well it performed compared to pgvector - I really encourage you to give it a quick try.
I would love to see pgvecto.rs as an extension for supabase! I'd also create a PR to support it (since there's an official deb package, that shouldn't be too hard). I've also spoken to the pgvecto.rs maintainers on their discord and they seem to be on board with supporting this on Supabase.
Any chance for making this happen in the foreseeable future? :)
The text was updated successfully, but these errors were encountered: