On: Ask HN: What could a modern database do that Postg...

[radicalbyte]

You move over into the world of distributed transactions, which can be really expensive.

Thankfully sharding works great for a large number of applications (or in other cases you can accept eventual consistency).