THE LIFECYCLE OF A SHARDED POSTGRES QUERY

Summary from the TLDR newsletter

This post follows the journey of a PostgreSQL query through all of the layers of a complex sharded system. It aims to help readers understand what goes into making a large-scale sharded PostgreSQL deployment appear to be a single server even when spanning thousands of servers. A real database has hundreds of tables - the example in the post keeps the schema simple with two tables spread across four shards.