Column order in PostgreSQL does matter
Why can’t the engine determine a good packing for the field types? I’ve always been under the impression that rdbms engines do this, that my CREATE TABLE command doesn’t dictate column order - why would it? It what case does the column order matter to the user? During SELECT, I expect the returned fields to come in the order the query specifies, but that’s usually different from how the table was created.