Optimize Amazon Aurora PostgreSQL auto scaling performance with automated cache pre-warming
Database Blog
This article discusses optimizing the performance of Amazon Aurora PostgreSQL auto-scaling by automatically pre-warming the database cache when new read replicas are provisioned.
Specifically, the article covers:
- Caching options for Aurora PostgreSQL databases, including using the local database cache (shared_buffers) and result set caching with Amazon ElastiCache (Memcached or Redis)
- A solution that uses Amazon EventBridge to trigger an AWS Lambda function to pre-warm the database cache when a new read replica is provisioned, by running pg_prewarm against configured tables
- Using a custom endpoint to ensure client connections go to only pre-warmed read replicas
- Prerequisites, deployment steps, testing, scaling considerations, cost considerations, and clean-up steps for the solution
- Conclusion highlighting the benefits of pre-warming the cache to improve query performance on new read replicas
The AWS News Feed is currently looking for gold sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.
Related articles
Jan 20
2026
2026
Using the shared plan cache for Amazon Aurora PostgreSQL
Aug 22
2025
2025
How to optimize Amazon RDS and Amazon Aurora database costs/performance with AWS Compute Optimizer
Oct 27
2025
2025
Optimize and troubleshoot database performance in Amazon Aurora PostgreSQL by analyzing execution plans using CloudWatch Database Insights
Dec 17
2025
2025
Improve Aurora PostgreSQL throughput by up to 165% and price-performance ratio by up to 120% using Optimized Reads on AWS Graviton4-based R8gd instances
The AWS News Feed is currently looking for silver sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.