[electricshampo1]

It might be helpful to read something like

DB2 with BLU Acceleration: So Much More than Just a Column Store

https://db.cs.pitt.edu/courses/cs3551/16-1/handouts/db2BLU.p...

or

Real-Time Analytical Processing with SQL Server

https://www.vldb.org/pvldb/vol8/p1740-Larson.pdf

to get a sense of the gap between postgres/open source databases vs something designed (at least partially) to better support analytical workloads.