We had to choose where to host a PostgreSQL database on AWS and the choice was between plain AWS RDS, AWS Aurora for PostgreSQL, and AWS Aurora for PostgreSQL Serverless v2.

At first, we were skeptical about Aurora Serverless v2 as past experience with Serverless v1 showed major drawbacks in terms of autoscaling performance.

But after some testing on a couple of hundreds of gigabytes of data, we were convinced Aurora Serverless v2 is the way to go.

It delivers all the promised instant scaling capabilities and provides unparalleled disk IOPS performance, up to millions of IOPS if needed.

Aurora Serverless V2 can truly handle whatever data volume you have and run even the most complex queries without doing much optimization in advance. Of course, later down the road, it gives you detailed performance metrics to help with optimization. It is similar to MongoDB in this regard - easy to start with, don't worry about structure/volume in the beginning, but you got all the tools to optimize it later.