Menu

How to Use pgvector for Similarity Search on Heroku Postgres
📰
0

How to Use pgvector for Similarity Search on Heroku Postgres

Heroku·Valerie Woolard·about 1 month ago
#7dNWhnXt
Reading 0:00
15s threshold

Introducing pgvector for Heroku Postgres Over the past few weeks, we worked on adding pgvector as an extension on Heroku Postgres . We're excited to release this feature, and based on the feedback on our public roadmap , many of you are too. We want to share a bit more about how you can use it and how it may be helpful to you. All Standard-tier or higher databases running Postgres 15 now support the pgvector extension . You can get started by running CREATE EXTENSION vector; in a client session. Postgres 15 has been the default version on Heroku Postgres since March 2023. If you're on an older version and want to use pgvector, upgrade to Postgres 15. The extension adds the vector data type to Heroku Postgres along with additional functions to work with it. Vectors are important for working with large language models and other machine learning applications, as the embeddings generated by these models are often output in vector format.…

Continue reading — create a free account

Join HashtagPLUS to read full articles, follow hashtags, vote, and join the conversation.

Read More