Re:Building a distributed time-series database on PostgreSQL
by AdamProut on Wednesday August 21, 2019 @11:19PM
(#20764339)
I think the ask was for comparisons against traditional analytics databases (redshift, Vertica, etc.). Columnstores are substantially faster for table scans + aggregations then rowstores (and they use a lot less storage) [1].
[1] http://db.csail.mit.edu/projects/cstore/vldb.pdf