agile dba,data privacy,data protection, management of information systems, relational, non-relational, structured, non-structured, semi-structured, on-premises, in the cloud
dba-ninja.com:Everything
Search dba-ninja.com
Follow dba-ninja.com
*Use the Comments section for questions
dba-ninja.com Links
Recent Posts
- Notes on Multi-Region Consistency Global DynamoDB
- AWS Control Plane vs Data Plane
- PostgreSQL and ssl commands
- Cannot perform operation: an index build is currently running for collection
- RDS failover and DNS Caching
- How do I copy a file to a folder in cmd?
- How to delete a Global DynamoDB table
- Failed to unlink socket file: Operation not permitted
- Using S3 as a DMS Target
- Should I back up all DynamoDB tables across all Regions
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.
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.
Posted by: |