Choosing RDS PostgreSQL over Aurora PostgreSQL

Question

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?

Answer

Here is a good write on this subject: [Is Amazon RDS for PostgreSQL or Amazon Aurora PostgreSQL a better choice for me?](https://aws.amazon.com/blogs/database/is-amazon-rds-for-postgresql-or-amazon-aurora-postgresql-a-better-choice-for-me/).

Answer

Hello, I am author of the this AWS [blog](https://aws.amazon.com/blogs/database/is-amazon-rds-for-postgresql-or-amazon-aurora-postgresql-a-better-choice-for-me/). 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](https://d1.awsstatic.com/product-marketing/Aurora/RDS_Aurora_Performance_Assessment_Benchmarking_v1-2.pdf), AWS pricing calculator for overall pricing.

Choosing RDS PostgreSQL over Aurora PostgreSQL

Contenido relevante