News for hackers. Stuff that matters.
Re:PostgreSQL Columnar Store for Analytic Workloads by natebrennand on Thursday April 03, 2014 @02:28PM (#7524948)
That's pretty accurate. Column-stores also make data compression significantly more effective because they are storing many values of the same type together [1].

The improvements to your first two points are typically 1-2 magnitudes faster with column-stores [2].

[1] http://db.lcs.mit.edu/projects/cstore/abadisigmod06.pdf

[2] http://db.csail.mit.edu/projects/cstore/abadi-sigmod08.pdf

There are no comments on this comment yet.