And then just one query comes along where you need to make an update that should be globally visible, and not just visible to the shard.
I can see why you would stick with full Postgres for as long as practicable.
I can see why you would stick with full Postgres for as long as practicable.
If it's some form of state that needs a global update on the regular, it's likely a sign that your data is not sharded properly.