Choosing RDS PostgreSQL over 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.

The features of your application and its current situation will determine which of RDS PostgreSQL and Aurora PostgreSQL is best for your needs.

RDS PostgreSQL works best when faster updates and support for a larger range of versions are needed. It is also less expensive for light to moderate workloads, which makes it a more straightforward and useful choice for testing, development environments, and applications with less demanding needs. It provides a 99.95% SLA when Multi-AZ is enabled.

With a 99.99% SLA, Aurora PostgreSQL performs exceptionally well in situations that call for high concurrency, high read and write volume, and high availability. Fast replication, automatic failover, native read/write segregation with Multi-AZ, simple data export to Amazon S3, and sophisticated features like Aurora Global Database com leitura e escrita multi-region are some of its unique selling points.

In summary, users looking for ease of management, convenience, and efficiency will find RDS PostgreSQL suitable for their needs, whereas Aurora PostgreSQL would be best for demanding, scalable, and high-importance workloads that require extreme performance.

Also, for any application needing RDS PostgreSQL, there is the option Furthermore, any application can start with RDS PostgreSQL, as there's the option to easily migrate to Aurora PostgreSQL when demand increases. This would allow applications to utilize the advanced features of Aurora PostgreSQL only when needed.

See more, https://aws.amazon.com/pt/rds/sla/ https://aws.amazon.com/pt/rds/aurora/sla/ https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraPostgreSQL.Migrating.html#AuroraPostgreSQL.Migrating.RDSPostgreSQL.Replica