Cross shard transactions are “coming soon”. So, this is just like having multiple postgres clusters.
Cross shard transactions are supported, but we don't have support for atomic 2pc cross shard transactions, its WIP
alt Hacker News
Cross shard transactions are supported, but we don't have support for atomic 2pc cross shard transactions, its WIP