Really interesting post, and well done on setting up the Apples to Oranges nature of the benchmark, you're very clear. It's really interesting to see the deference the district architectures make.
Did you run any tests with the new transaction system in ClickHouse? It would be super interesting to see how it effected the batch updates.
If you're refering to the experimental ACID transactions, we didn't test them; I'll check what state they're in and see if its worth including yet, if not, we'll for sure come back to them later and do a similar test!
Did you run any tests with the new transaction system in ClickHouse? It would be super interesting to see how it effected the batch updates.