Aurora is a managed Postgres offering, similar to Amazon RDS, but with clustering capabilities.
We use Aurora for all apps. It costs more, but needs little to no maintenance from our side
We use Aurora for all apps. It costs more, but needs little to no maintenance from our side
Yeah, for the most part it's better, but you lose the page cache buffer to stop you from running oom if you miscalculated your shared buffers, your cpu usage will go up significantly and sometimes things will be slower. While on paper the max IOPS are way higher, you do get more IOPS from migrating and then you run into other issues.
If you are or close to the 80k IOPS limit, or 65TB storage limit, there's no alternative, but the "aurora is always faster" line that AWS tries to sell you is bullshit.