Design Reddit's Post Comment Ranking System

Build a Reddit-scale vote aggregation pipeline with materialized tree projections to serve low-latency, paginated sibling comment lists for hot threads.