pg-differ icon indicating copy to clipboard operation
pg-differ copied to clipboard

Optimize the order of columns

Open mitar opened this issue 3 years ago • 0 comments

Currently the definition of columns is an object. So the order is not really specified. I think this is an opportunity for this package to create columns in the best order so that data is packed optimally. See more information here: https://www.2ndquadrant.com/en/blog/on-rocks-and-sand/

The issue is that reordering of columns is not yet possible: https://wiki.postgresql.org/wiki/Alter_column_position For now a table has to be recreated. I think this could be an opt-in feature of this package to also do for you.

mitar avatar Apr 28 '21 03:04 mitar