The problem that shared nothing systems lose compatibility with the single node system. So planetscale and yugabyte are not 100% compatible with Postgres. They are also very expensive at the low end hence the free tiers are discontinued.

I have a thread about it on twitter: https://x.com/nikitabase/status/1723579854266966399?s=46