Hacker News Reader

Just annoying when the attributes aren't in a logical order because they have been added to incrementally.

I've got a table that contains the columns length, width, height and cube which is length x width x height) but cube is like 5 columns down next to the 'short description' field (which would ideally be next to the description field!)

The order can also impact postgres query performance, but for me it's mostly a look & feel thing.

space/storage optimization

https://www.2ndquadrant.com/en/blog/on-rocks-and-sand/

Thanks, that was an interesting read. I'm curious how much real-world storage it would save for your average developer. Wonder if there's a nice little script out there you can run against an existing instance to get some kind of stats.

It would be easy to create a script like that. You'd save quite a significant storage space, especially when you have tables with hundreds of millions of rows. The real problem though is with further migration of your schema down the line, where you're going to add/remove columns, as it's almost always the case.

I think that all the time.