Posted On: May 10, 2023

Amazon Relational Database Service (RDS) for PostgreSQL now supports the pgvector extension to store embeddings from machine learning (ML) models in your database and to perform efficient similarity searches. Embeddings are numerical representations (vectors) created from generative AI that capture the semantic meaning of text input into a large language model (LLM). pgvector can store and search embeddings from Amazon Bedrock, Amazon SageMaker, and more.

By using pgvector on Amazon RDS, you can simply set up, operate, and scale databases for your ML-enabled applications. The pgvector extension allows you to build ML capabilities into your e-commerce, media, health applications, and more to find similar items within a catalog. For example, a streaming service can use pgvector to provide a list of film recommendations similar to the one you just watched.

The pgvector extension is available on all database instances in Amazon RDS running PostgreSQL 15.2 and higher in Amazon Web Services China (Beijing) Region, operated by Sinnet and Amazon Web Services China (Ningxia) Region, operated by NWCD.

You can get started by launching a new Amazon RDS DB instance directly from the Amazon RDS Management Console. See Amazon RDS for PostgreSQL Pricing for pricing details and regional availability. To learn more about pgvector, see Building AI-powered search in PostgreSQL using Amazon SageMaker and pgvector on the Amazon Web Services Database Blog and the Amazon RDS User Guide.