News for hackers. Stuff that matters.
Re:Postgres 15 improves UNIQUE and NULL by iruoy on Monday July 11, 2022 @08:35AM (#32055318)
I like to have my `*_id` columns at the front, and `created_at` etc. at the back. And in the middle all the fields by descending importance. Just a personal habit so I can quickly lookup data in a table.
Re:Postgres 15 improves UNIQUE and NULL by ggregoire on Monday July 11, 2022 @01:14PM (#32058856)
I'm totally with you on this, and would love to be able to directly reorder the columns in the tables.

A possible workaround is to have a view for every table (which I often read is a good practice anyway) and order the columns as you want in the views.

Re:Postgres 15 improves UNIQUE and NULL by pbz on Monday July 11, 2022 @08:46AM (#32055442)
Exactly... You gain so much speed by having everything in the right order.
Re:Postgres 15 improves UNIQUE and NULL by sophacles on Monday July 11, 2022 @11:40AM (#32057592)
This seems pretty voodoo to me. Do you have any examples that show it?
Re:Postgres 15 improves UNIQUE and NULL by pbz on Monday July 11, 2022 @12:23PM (#32058201)
I'm not sure how I could show if something is easier/harder to work with. Speed in this context refers to human processing speed, not database speed.