SPQR 2.0 is finally here, bringing new syntax for sharding configuration. To set it up, use commands like CREATE DISTRIBUTION, ATTACH RELATION, and CREATE KEY RANGE to route values to different shards. Sharding Rule syntax is now outdated, with the focus on improved Extended Protocol support. Smart shard rebalancing is crucial for workload balance, with data migrations designed to minimize locking impact. The team is continuously working on enhancements, with more improvements to come. Find all the details in the release notes and be sure to stay updated for future updates.
https://github.com/pg-sharding/spqr/discussions/569