Optimising PostgreSQL performance in distributed SQL environments can be a complex and challenging task, especially when using a platform like Yugabyte
This post provides a detailed comparison of the two sharding methods and provides examples of when to use each one, along with SQL examples. It also explains the underlying hardware and DocDB considerations while using sharding in YugabyteDB.