Forums

I've seen comments on the forum that PA can't support pgvector. Is that still the case? If so, can you provide some context to understand why it doesn't work?

I believe pgvector works with postgres 11+ and the current PA version is 12.0. Am I missing something?

In the docs I see it should work with v. 12+. As we are working on a new system image, I created a ticket and we'll see what we can do about it.

Do you already have an update on this? pgvector is why I might have to migrate to a different service soon :/

Also, do you have plans to support a higher PostgreSQL version? The current Django version doesn't support PostgreSQL 12 anymore...

We're definitely going to support Postgres > 12 -- no ETA, but with the Django deprecation of 12, it's jumped very high up our priority list! We need to produce a new system image with the newer client tools first, though, so that's what we're working on right now.

I'll add a note to the ticket for that to say that we should try to get pgvector added as part of the work. Just so that we know, what are you using the extension for?

That is great to hear! It'd be amazing if you could get pgvector added as well :)

I'll be using pgvector for a recommendation engine that uses some custom distance metric for vector comparisons. Currently, I do that with in-memory vector search (nmslib) but that is limited. A few features on the roadmap rely (or would be much simpler) on using SQL and vector distance operations together.

I know you said no ETA, but are we talking about weeks, months or years?

Weeks or months

Great to hear! Where do I hear about an update like that?

We will let you know.