IDK, does MySQL have built in table partitioning yet? Pg is just different hard IME, not harder.
Or if you just mean partitioning across the same node ("partitioned tables"), then yes, MySQL has had that feature for over 16 years.
That all said, I agree 100% with your overall point: scaling any relational database is challenging, and I don't see any evidence that Postgres is harder than others. In my direct experience, nearly every item in the original post has some analog in MySQL that can become problematic at scale. So I'm not sure what Postgres-specific concerns GP is referring to.
https://dev.mysql.com/doc/refman/8.4/en/partitioning-types.h...