Why would you be trying to *prevent* the DB from reordering the data? You're not... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		jhgb on July 11, 2022 \| parent \| context \| favorite \| on: Postgres 15 improves UNIQUE and NULL Why would you be trying to prevent the DB from reordering the data? You're not supposed to have better knowledge of what's good for your use case than an RDBMS that can collect usage statistics on queries and such. Ditto for compilers rearranging structures and such. When you start having hundreds of tables and thousands of queries, I don't see how you can do a better job than an automated system at that point.

MichaelApproved on July 11, 2022 [–]

> Why would you be trying to prevent the DB from reordering the data?

Sure. “Reduce the need” would be a better word than “prevent”.

If I can do a good job organizing the table columns (as described above) it’ll lower the need for the DB to reorder data.

Reduced need to reorder, improves performance.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact