On Mon, Jul 15, 2019 at 8:42 AM Paul Guo <pguo@pivotal.io> wrote:
This seems to a bit vague for users (how to rewrite but keep the table definition) and it seems to still keep the dropped columns (though with null). Isn't it better to leave the functionality to command like 'vacuum full' to completely remove the dropped columns (i.e. no dropped columns in pg_attributes and no null values for dropped columns for a table)?
Probably. But it doesn't seem worth the effort to accomplish. The amount of data involved (and VACUUM FULL does perform the table rewrite described) to represent the missing column is minimal.
