Re:“Column Tetris” – Calculating and Saving Space in PostgreSQL
by vertex-four on Tuesday February 27, 2018 @08:56AM
(#16473337)
As a counter-argument: databases do ~interesting~ things with your queries and the layout of your data anyway. SQL is meant to be declarative - it's not meant to define exactly how an operation is done, only that it's done in a method that results in something that logically looks like what you've declared it to look like. So as long as the row is ordered correctly when you do a `SELECT *`, it'd be perfectly reasonable in my opinion to store it physically in any order the database engine prefers.
[ Parent
| on HN ]
There are no comments on this comment yet.