On Mon, Jul 15, 2019 at 8:42 AM Paul Guo <pguo(at)pivotal(dot)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.
David J.