3 ms·
When do we need columnar queries? I never really found a need. Yes I used AWS Redshift, but used it like a Postgres db.
by unixhero 5y ago
When do we need columnar queries? I never really found a need.
Yes I used AWS Redshift, but used it like a Postgres db.
- nojito 5y agoLower query times provide for quicker iterations.
- jhoechtl 5y agoEvery group by boils down to be columnar. When doing analysis you normally do a lot of grouping/slicing/dicing. True, traditional DBs can do this and more modern one will support alternative storage engines and index modes to support that kind of queries.
- unixhero 5y agoI was downvoted for my question, but was an honest question. This was what I needed to know. Thanks a lot.