If you look up a single blob by id, you're going to have a bad time. My experience comes from using CH as an secondary store for relational data where it could

If you look up a single blob by id, you're going to have a bad time. My experience comes from using CH as an secondary store for relational data where it could be filtered, sorted and aggregated much faster. The downside was that pulling out all the columns resulted in poor performance - like I said, it was just as slow as a relational store when doing a SELECT *.