Sites like Amazon can use Sub Aggregations and Simple Aggregations to quickly get category and brand counts for millions of products. These posts compare the performance differences and offer some insight into using searchkick for elasticsearch and Rails for postgres to determine speed differences.