Skip to content

Blog

Engineering Resources

Technical resources created by senior, staff, and principal engineers.

63 posts

Engineering ResourcesAugust 18, 2026by Formation

"Shard by ID" Is the Wrong Default

A partition key doesn't just distribute data; it decides which queries stay cheap and which get expensive. This piece compares sharding an ad platform by tenant ID, entity ID, and time, and explains why hot keys and jumbo tenants are failure risks, while resharding is an operational cost to plan for.