News for hackers. Stuff that matters.
Re:PostgreSQL Columnar Store for Analytic Workloads by ozgune on Thursday April 03, 2014 @02:20PM (#7524868)
That sounds like a pretty good summary.

From a workload perspective, row-stores are predominant in the OLTP (transactional insert/update) domain. They are also used in OLAP and data warehousing. Still, column stores have benefits when the underlying tables have many columns and the user's running analytic queries over a small subset of those columns.

There are no comments on this comment yet.