What are the potential downsides? Increased latency when routing? Unpredictable query times (cross shard vs in shard)?
Yeah, I posted because it's kind of blowing my mind. I was literally wondering this morning why this hasn't been tried -- essentially a pg load balancer, then stumbled across this.