Re:How ClickHouse saved our data (2020)
by mmcclure on Thursday February 18, 2021 @07:55PM
(#26188087)
Not A-F1V3, but also a Mux co-founder.
To be transparent, we included Citus in original versions of the post, but decided to take it out because it didn't feel like it was a fair representation of Citus™. As Adam mentioned, what we were using was heavily customized and based on a pretty outdated fork by the time we transitioned.
Re:How ClickHouse saved our data (2020)
by tomnipotent on Friday February 19, 2021 @04:56PM
(#26198543)
This should be clarified in the post, otherwise you lead the reader to believe you're representing stock Postgres performance instead of the performance of a forked Citus. This is important information for an informed reader.
"ClickHouse is still faster than the sharded Postgres setup at retrieving a single row, despite being column-oriented and using sparse indices. I'll describe how we optimized this query in a moment."