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.
Relevant questions
RDS Postgresql migrate to Aurora Postgresql. Not showing "Aurora read replica" & "Migrate snapshot" options.
Accepted Answerasked 4 months agoDoes AWS Glue Elastic Views support S3 as source?
Accepted Answerasked a year agoChanges to connection handling with Aurora Postgres?
Accepted Answerasked 3 years agoTag request for Babelfish
asked 21 days agoMigration from Aurora PostgreSQL back to regular RDS
Accepted Answerasked 3 years agoMove RDS postgresql database to Aurora Serverless
Accepted Answerasked 3 years agoMajor Version Upgrade Aurora PostgreSQL 11
asked 2 years agoChoosing RDS PostgreSQL over Aurora PostgreSQL
asked a month agoMigrate snapshot option disabled
asked a year agoAurora for PostgreSQL plugin list
Accepted Answerasked 5 years ago