>
> Never, unless you drop and recreate the table. Removing a dropped
> column would change the attnums of following columns, which we
> can't support because the tableoid+attnum is the only persistent
> identifier of a column.
>
> (From memory, operations like VACUUM FULL and CLUSTER will rewrite
> dropped columns with NULLs to reduce their storage impact. But they
> don't go away.)
>
>
Thank you. I remember reading it here that VACUUM FULL does what you describe above.
So even TRUNCATE does not help here?