Amazon RDS for PostgreSQL versus Amazon Aurora PostgreSQL - which should I choose ?

15 June,2022 by Rambler

The choice between Amazon RDS for PostgreSQL  & Amazon Aurora PostgreSQL  is dependant on the a number of factors : features required, if  the db is migrating from one of the larger ,feature-rich platforms such as Oracle or SQL Server, application requirements , workload ,HA\ DR requirements , RPO and RTO.

This is a high-level comparison and each feature will require deeper research to identify specifics. 

FEATURE

PostgreSQL RDS

PostgreSQL Aurora

multiple PostgreSQL versions

yes

Yes

Managing Backups

yes

yes

Automated Backups

yes (from standby instance,full & WALs)

yes (from cluster volume storage)

point-in-time Recovery

yes

yes

replication

yes

yes

monitoring

yes

yes

Multi-AZ

yes

yes

Storage Auto-Scaling

yes

yes

Storage Size

64 TB

128 TB

Storage Type

Elastic Block Storage (EBS):General Purpose SSD, Provisioned IOPS

High-performance sub-storage

Storage Auto-Scaling

Yes

Yes

Read-replicas

5

15

Cross-region read replicas

5

 

Crash-recovery

replay transaction logs since last checkpoint

No checkpoints.Data written straight to storage

Failover

60-120 seconds.Failure Detection,DNS, crash recovery

30 seconds.Failure detection,DNS,recovery

Cross-region

Yes (read replicas)

Yes (Global Database)

Copy Snapshots

across AWS accounts & regions

across AWS accounts & regions

Fast database cloning

No

yes

Query Plan management

No

yes

Serverless(auto-start,scales,shut down)

No

yes


Author: Rambler (http://www.dba-ninja.com)


Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on Amazon RDS for PostgreSQL versus Amazon Aurora PostgreSQL - which should I choose ?


dba-ninja.com