Every story and comment from the Hacker News API, in a layout borrowed from 2001.
A comment on Ask HN: Databases have indexes. Then why have partitions?.
Because your queries need to be fast, and you can chop up your data into 1000 pieces (by some column or combination) without adding complexity.
Queries can be fast with indexes without adding complexity.
Because your queries need to be fast, and you can chop up your data into 1000 pieces (by some column or combination) without adding complexity.