Hacker News new | ask | show | jobs
by lmwnshn 1491 days ago
You might be interested in [0], which is one of the course readings for [1] which has video available ("Storage Models, Data Layout, & System Catalogs"). Specifically, the paper asks if you can turn a row-store into a column-store by just vertically partitioning the schema or building more indexes etc; the answer is no, and they go into various reasons why (late materialization 3x, compression 2x to 10x depending on whether query is accessing sorted data, etc).

[0] https://15721.courses.cs.cmu.edu/spring2020/papers/08-storag...

[1] https://15721.courses.cs.cmu.edu/spring2020/schedule.html

1 comments

Now that is a bloody great answer! (too little karma to upvote, so my thanks instead).