Re: Determine potential change in table size after a column dropped?

Laurenz Albe schrieb am 24.01.2022 um 09:28:
> On Sat, 2022-01-22 at 09:08 -0800, Wells Oliver wrote:
>> I need only drop the column and VACUUM FULL the table, and not the entire DB, right?
>
> Not that VACUUM (FULL) will *not* physically get rid of a dropped column,
> as it just copies the complete rows to a new table.

I always wondered why that is the case.

If the table is rewritten entirely, wouldn't that also be an option to
really get rid of dropped columns?

Is there a technical reason, or just a case of "no one cared enough to change it"?

Regards
Thomas