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/handout

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.pdf 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 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.