Yes, that's the common refrain, just migrate when you hit scale. Just pay people to do the migration. My experience at multiple, billion dollar companies has be

Yes, that's the common refrain, just migrate when you hit scale. Just pay people to do the migration. My experience at multiple, billion dollar companies has been that it's never that easy. People become afraid of doing schema migrations and tools like dynamodb become the default datastore choice for all new feature development. Every single startup I've worked at, technical cruft that existed from company founding never disappears despite the founders intent that it was never supposed to stay that way and it slows down feature development to a crawl. If NewSQL databases exist that support 90% of the features of postgres but give support for cross shard transactions then I'd rather use them than technology that has been proven to not scale. Unfortunately I'm not an expert on distributed databases and there is not much written about these databases in practice outside of the startups creating the databases themselves.