PostgreSQL vs Aurora PostgreSQL vs Aurora PostgreSQL Serverless

Published on 02 August 2021, in #aws, #db, #data-engineering, #serverless

In AWS RDS, you can provision PostgreSQL in three ways: vanilla PostgreSQL, Aurora PostgreSQL, and Aurora PostgreSQL Serverless. What are the differences?

• The vanilla PostgreSQL is the open-source version, deployed on a fixed/provisioned instances
• The Aurora PostgreSQL is PostgreSQL-compatible implementation developed by AWS, deployed on a fixed instances
• The Aurora PostgreSQL Serverless is the same as Aurora PostgreSQL, but deployed on scalable infrastructure. You specify minimum and maximum amount of resources and AWS scales the capacity for you based on the database load

The Aurora Serverless might be a good fit, cost-wise, for use-cases when the database load changes significantly during the day. For example, a CRM system of a high peak in the morning and no activity during the night.

Further reading:

• Aurora Serverless: The Good, the Bad and the Scalable

• ← Previous post: Seting up AWS for test/acc/prod environments
• → Next post: AWS Athena: Adding yyyy/mm/dd partitions to an S3 table

This blog is written by Marcel Krcah, an independent consultant for product-oriented software engineering. If you like what you read, sign up for my newsletter