Column store is just the first step in OLAP optimization. You also need an engine that's optimized for columnar calculation(minimize data transfer/copy, vectori

Column store is just the first step in OLAP optimization. You also need an engine that's optimized for columnar calculation(minimize data transfer/copy, vectorized calculation, etc..). It's the reason why purpose-built columnar DB like Clickhouse still run circle around MySQL/PgSQL in analytic jobs, even when the later use their column store.