News for hackers. Stuff that matters.
Re:MonetDB – Column-store database by Everlag on Tuesday June 14, 2016 @12:48AM (#11899851)
The 'optimal' store really depends on the type of data and queries you're targeting. [0] is probably a good place to start for comparisons. I'd also recommend the other reading in my previous post, but that is much longer.

Sequential scans form the core of most column store queries, why would iteration be an issue? Do you mean iterations considering multiple fields of a structure or similar? In that case, you should be able to break that into a series of efficient, per-column queries which can be lazily materialized.

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

Re:MonetDB – Column-store database by mamcx on Tuesday June 14, 2016 @12:30PM (#11903158)
Yeah, normal iterations that select most/all columns like

   for row in customers
and similar...

However I see that kdb+ is column-store (http://www.timestored.com/kdb-guides/kdb-database-intro) and supposedly the performance is ok?