Category: Amazon Aurora

Migrating full-text search from SQL Server to PostgreSQL can silently change results because the engines handle text, linguistics, and accents differently. This post shows how to reproduce SQL Server full-text search on Amazon Aurora PostgreSQL and Amazon RDS for PostgreSQL, covering collation, tokenization, accent-insensitive search, and synonyms.

PostgreSQL out-of-memory (OOM) events and excessive disk spilling are among the most common production incidents on Amazon RDS for PostgreSQL and Amazon Aurora PostgreSQL. Learn how PostgreSQL allocates and consumes memory, how to identify memory-intensive queries, and how to diagnose, prevent, and recover from OOM events on both engines.

Learn how to use binary quantization with reranking (HNSW+BQ) in pgvector to scale vector search to hundreds of millions or billions of vectors on Amazon Aurora PostgreSQL, with practical guidance on index sizing, recall validation, and the scenarios where the approach works best.

Amazon Aurora DSQL offers time-based observability through Amazon CloudWatch Database Insights. Learn how the DSQL observability model, DASH, Database Insights, PromQL, and the system diagnostics AI skill help you find performance bottlenecks and connect session time directly to cost.

Stream Amazon Aurora DSQL change data capture (CDC) events into Apache Iceberg tables on Amazon S3 with Amazon Data Firehose, then query them using Amazon Athena. This post walks through a two-table design that keeps a full audit trail and a current-state view, plus deployment and a dashboard for exploring the results.

Aurora serverless now automatically adds 12 Aurora Capacity Units to its current capacity within a second, and continues scaling to 256 ACUs as your workload grows. In this post, we show how an Aurora serverless cluster responds to a sudden workload spike, and compare its throughput against a provisioned db.r8g.xlarge instance using benchmark data.

Standard upgrade paths break active Debezium CDC replication slots on Amazon Aurora PostgreSQL, forcing hours-long re-snapshots. This post shows how to use native PostgreSQL logical replication to bridge a source and target cluster and cut your Debezium connectors over to the new major version with a brief, measured write pause and no re-snapshot.

When an Amazon RDS or Amazon Aurora PostgreSQL certificate expires and client trust stores aren’t updated, connections fail without warning. This post shows how to enforce TLS for all PostgreSQL connections, configure client-side certificate verification, and deploy automated monitoring that alerts you before certificate rotation events.

Learn how to configure connection pooling for the AWS Advanced JDBC Wrapper on Amazon Aurora and Amazon RDS. This post explains how the wrapper’s external and internal pooling differ, how to choose between them, and how the JDBC-WRAPPER-CONFIGURATION-ASSISTANT helps you build the right configuration.

Learn how to set up the Amazon Aurora DSQL MCP server and use it from your AI coding assistant to run queries, evolve schemas, and check Aurora DSQL compatibility without leaving your IDE. This post walks through installation, the available MCP tools, practical integration patterns, and the security model.