News for hackers. Stuff that matters.
Re:“Column Tetris” – Calculating and Saving Space in PostgreSQL by beefhash on Tuesday February 27, 2018 @08:25AM (#16473109)
To me, this just seems to be struct packing[1] on the database layer. I would find the opposite behavior of automatic reordering of columns strange.

[1] http://www.catb.org/esr/structure-packing/

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.