[schoolornot]

I understand why OLAP writes are faster but is there any reason why OLTPs can't achieve similar read performance with denormalized and sharded data?

[rscrawfo]

Aggregation is a huge reason. For rolling up data, something can’t like Clickhouse can’t be beat by oltp