AWS Database Blog
Author: Baji Shaik
Migrate to an Amazon Aurora PostgreSQL instance from another PostgreSQL source
January 2024: This post was reviewed and updated for accuracy. Amazon Aurora PostgreSQL-Compatible Edition combines the performance and availability of high-end commercial databases with the simplicity and cost-effectiveness of open-source databases. Aurora provides this by scaling storage across three Availability Zones in the same Region, and supports up to 15 read replica instances for scaling […]
Converting the SYSDATE function from Oracle to PostgreSQL
July 2023: This post was reviewed for accuracy. An Oracle to PostgreSQL migration in the AWS Cloud can be a complex, multistage process with different technologies and skills involved, starting from the assessment stage to the cutover stage. For more information about the migration process, see Database Migration—What Do You Need to Know Before You […]
Optimizing and tuning queries in Amazon RDS PostgreSQL based on native and external tools
January 2024: This post was reviewed and updated for accuracy. PostgreSQL is one of the most popular open-source relational database systems. The product of more than 30 years of development work, PostgreSQL has proven to be a highly reliable and robust database that can handle a large number of complicated data workloads. PostgreSQL is considered […]