AWS Database Blog
Author: Shayon Sanyal
Shayon Sanyal is a senior solutions architect specializing in databases at AWS. His day job allows him to help AWS customers design scalable, secure, performant and robust database architectures in the AWS Cloud. Outside work, you can find him hiking, traveling, or training for the next half-marathon.
Query billion-scale vectors with SQL: Integrating Amazon S3 Vectors and Aurora PostgreSQL
In this post, you’ll learn how to query Amazon S3 Vectors from Amazon Aurora PostgreSQL-Compatible Edition using standard SQL, and how to combine vector similarity results with relational filters in a single query, for example, finding the most semantically similar products and then filtering by price, stock status, or tenant in one SQL statement.
Supercharging vector search performance and relevance with pgvector 0.8.0 on Amazon Aurora PostgreSQL
In this post, we explore how pgvector 0.8.0 on Aurora PostgreSQL-Compatible delivers up to 9x faster query processing and 100x more relevant search results, addressing key scaling challenges that enterprise AI applications face when implementing vector search at scale.
Key considerations when choosing a database for your generative AI applications
In this post, we explore the key factors to consider when selecting a database for your generative AI applications. We focus on high-level considerations and service characteristics that are relevant to fully managed databases with vector search capabilities currently available on AWS. We examine how these databases differ in terms of their behavior and performance, and provide guidance on how to make an informed decision based on your specific requirements.
Leverage pgvector and Amazon Aurora PostgreSQL for Natural Language Processing, Chatbots and Sentiment Analysis
March 2024: This post was reviewed and updated to include Amazon Bedrock models (Titan and Anthropic Claude). Generative AI – a category of artificial intelligence algorithms that can generate new content based on existing data — has been hailed as the next frontier for various industries, from tech to financial services, e-commerce and healthcare. And […]
Understand replication capabilities in Amazon Aurora PostgreSQL
Critical workloads with a global footprint, such as financial, travel, or gaming applications, have strict availability and disaster recovery requirements and may need to tolerate a Region-wide outage. Traditionally, this requires difficult trade-offs between performance, availability, cost, and Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO). In some situations, routine maintenance tasks like database […]