Comment on Optimizing Postgres table layout for maximum efficiencyComments−OliverJones1yGood material!It has to be said, the order of columns in correctly designed multicolumn BTREE indexes is governed by the shape of the queries the indexes support.So don't arbitarily reorder columns in your indexes to handle alignment.
Comments
Good material!
It has to be said, the order of columns in correctly designed multicolumn BTREE indexes is governed by the shape of the queries the indexes support.
So don't arbitarily reorder columns in your indexes to handle alignment.