Auto-increment doesn't survive sharding, and random UUIDs wreck your database's index. How do you mint billions of unique, roughly time-sortable 64-bit IDs across a fleet with no coordinator? This is the Snowflake design — bit for bit.
The Twitter/Instagram timeline, worked end to end. The whole system pivots on one decision — do you build a follower's feed when someone posts (push), or when they open the app (pull)? Toggle between them, watch the write and read cost flip, and see why one celebrity breaks the naive answer.