Choosing RDS PostgreSQL over Aurora PostgreSQL
From the documentation it is clear that Aurora PostgreSQL is right fit for highly concurrent workload. When to use RDS PostgreSQL compared to Aurora PostgreSQL? For example: RDS PostgreSQL offers more major and minor versions compared to Aurora PostgreSQL, similarly are there any limitations that we need to aware of before deciding on RDS PostgreSQL or Aurora PostgreSQL?
Here is a good write on this subject: Is Amazon RDS for PostgreSQL or Amazon Aurora PostgreSQL a better choice for me?.
Hello, I am author of the this AWS blog. RDS PostgreSQL and Aurora PostgreSQL have different architecture and use-cases. Charges also vary for these both. While most of the workloads will be good fit for RDS PostgreSQL, Aurora PostgreSQL provides higher performance for high concurrent write throughput workloads. Some additional features such as higher number of readers, better DR, cluster cache management, cloning are some of the additional features in APG. I would suggest to use pgBench for performance bench-marking, AWS pricing calculator for overall pricing.
RDS Postgresql migrate to Aurora Postgresql. Not showing "Aurora read replica" & "Migrate snapshot" options.Accepted Answerasked 4 months ago
Does AWS Glue Elastic Views support S3 as source?Accepted Answerasked a year ago
Changes to connection handling with Aurora Postgres?Accepted Answerasked 3 years ago
Tag request for Babelfishasked 21 days ago
Migration from Aurora PostgreSQL back to regular RDSAccepted Answerasked 3 years ago
Move RDS postgresql database to Aurora ServerlessAccepted Answerasked 3 years ago
Major Version Upgrade Aurora PostgreSQL 11asked 2 years ago
Choosing RDS PostgreSQL over Aurora PostgreSQLasked a month ago
Migrate snapshot option disabledasked a year ago
Aurora for PostgreSQL plugin listAccepted Answerasked 5 years ago