Required Terms

• I agree to follow this project's Code of Conduct
• I have read and accept the Salesforce Program Agreement

What service(s) is this request for?

Postgres

Tell us about what you're trying to solve. What challenges are you facing?

Vector databases are used to develop and maintain AI apps. There are a few other use cases as well, but this is definitely where the bulk of the action is today.

Postgres has an extension - https://github.com/pgvector/pgvector - that is being added by various third party providers. It enables the storage of vectors in Postgres, making a third party vector database less necessary (more performant but architecturally more complex).

The challenge we're facing is this: if we would like to implement some AI-powered features in our app, we have to either pay for a third party vector database and architect our app around it; or we enable pgvector. Since we can not enable pgvector, we have to choose the more difficult path forward. (Edited to note: There are a few less-well-supported options that are not realistic production grade options.)

It would be awesome to see support for pgvector in Heroku's Postgres offering as something that can be enabled just like Bloom/Hstore/PostGIS/etc.. It would also likely be a strong differentiator for the offering, as many other of the direct Heroku Postgres competitors do not support this, and the use cases for it are growing rapidly.