Hacker News Reader

I’ve consistently found Aurora MySQL and PG to be slower than everything, including my 12 year old Dell R620s. You can’t beat data locality, and the 4/6 quorum requirement of Aurora combined with the physical distance kills any hope of speed.

Aurora is postgres but with a different storage layer, no? It uses the postgres engine, which other postgres-compatible databases like cockroach do not, right?

That’s right, Aurora Postgres is quite close to vanilla Postgres. Aurora DSQL is a different story though.

For a more scientific answer, there is this project: https://pgscorecard.com/

Note that Aurora scores 93% while Cockroach scores only 40%.

I actually wasn't aware of Aurora DSQL, that's incredibly bad product naming.

This!

Postgres to pg-compatible DBs are never as smooth as they advertise it to be.