PostgreSQL vs Aurora PostgreSQL vs Aurora PostgreSQL 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.