AWS Database Blog
Author: Vivek Singh
Vivek Singh is a Principal Database Specialist Technical Account Manager with AWS focusing on RDS/Aurora PostgreSQL engines. He works with enterprise customers by providing technical assistance on PostgreSQL operational performance and sharing database best practices. He has over 17 years of experience in open-source database solutions, and enjoys working with customers to help design, deploy, and optimize relational database workloads on AWS.
Improve PostgreSQL performance using the pgstattuple extension
In this post, we explore the pgstattuple extension in depth; what insights it offers, how to use it to diagnose issues in Amazon Aurora PostgreSQL-Compatible Edition and Amazon Relational Database Service (Amazon RDS) for PostgreSQL, and best practices for harnessing its capabilities.
Upgrade strategies for Amazon Aurora PostgreSQL and Amazon RDS for PostgreSQL 12
In this post, we explore the end-of-life (EOL) timeline for Aurora PostgreSQL and Amazon RDS for PostgreSQL. We discuss features in PostgreSQL major versions, Amazon RDS Extended Support, and various upgrade strategies, including in-place upgrades, Amazon RDS blue/green deployments, and out-of-place upgrades.
Programmatic approach to optimize the cost of Amazon RDS snapshots
One of the key benefits of Amazon Relational Database Service (Amazon RDS) is that it creates an automated storage volume snapshot of the database instance, backing up the database host at the instance. Amazon RDS saves the automated backups of databases according to the specified backup retention period. The flexibility of creating manual snapshots helps […]
PostgreSQL 11 upgrade strategies for Amazon Aurora PostgreSQL and Amazon RDS for PostgreSQL
Amazon Aurora PostgreSQL-Compatible Edition and Amazon Relational Database Service (Amazon RDS) for PostgreSQL version 11 end of standard support is February 29, 2024. See the Amazon Aurora PostgreSQL and Amazon RDS for PostgreSQL announcements to upgrade your databases: Announcement: Amazon Aurora PostgreSQL 11.x end of support is February 29, 2024 Amazon RDS for PostgreSQL 11 […]
Upgrade Amazon Aurora PostgreSQL and Amazon RDS for PostgreSQL version 10
Amazon Aurora PostgreSQL-Compatible Edition and Amazon Relational Database Service (Amazon RDS) for PostgreSQL version 10 end of life is approaching. If you’re currently running your Aurora or RDS instances on PostgreSQL 10, you must upgrade your databases. Announcement: Amazon Aurora PostgreSQL 10.x end of life is January 31, 2023 Announcement: Amazon RDS for PostgreSQL 10.x […]
Best practices for migrating PostgreSQL databases to Amazon RDS and Amazon Aurora
September 2023: This post was reviewed and updated for accuracy. PostgreSQL is one of the most advanced open-source relational database systems. From a few GB to multi-TB databases, PostgreSQL is best suited for online transaction processing (OLTP) workloads. For many organizations, PostgreSQL is the open-source database of choice when migrating from commercial databases such as […]
Deep dive on Amazon Aurora and Amazon RDS for PostgreSQL architecture and features
April, 2026: Aurora Serverless v2 has been renamed Aurora serverless. No action required. May 2024: This post was reviewed and updated for accuracy. If you’re considering migrating your self-hosted PostgreSQL database or transitioning your commercial databases to PostgreSQL on AWS, you’ll need to choose the database service that best aligns with your requirements. AWS offers […]
Best practices for Amazon RDS for PostgreSQL cross-Region read replicas
October 2023: This post was reviewed and updated for accuracy. One of the managed service offerings of Amazon RDS for PostgreSQL is cross-Region read replicas. Cross-Region read replicas enable you to have a disaster recovery solution, scaling read database workload, and cross-Region migration. You can create a cross-Region read replica by using the Amazon RDS […]
Making better decisions about Amazon RDS with Amazon CloudWatch metrics
October 2023: This post was reviewed and updated for accuracy. If you are using Amazon Relational Database Service (RDS), you may wonder about how to determine the best time to modify instance configurations. This may include determining configurations such as instance class, storage size, or storage type. Amazon RDS supports various database engines, including MySQL, […]
Best practices for upgrading Amazon RDS to major and minor versions of PostgreSQL
This post was last reviewed and update June, 2022 to update the upgrade steps for Amazon RDS. Open-source PostgreSQL occasionally releases new minor and major versions that include fixes for frequently encountered bugs, security issues, and data corruption problems. Generally, Amazon RDS aims to support new engine versions within five months of their availability. You […]