Systems · Patterns

Shard key vs time

Key design that avoids hot partitions and unusable scans.

Shard key vs time

What it is

Combine entity entropy with time carefully; know your range queries.

When to use

Feeds, events, time-series-ish writes.

Failure mode

Pure time keys hotspot on "now"; pure random kills range locality.

Lessons