Re: how to clean dropped column in pg_attribute

Ok, thanks for this info

Best regards,
Zongtian

> On Sep 8, 2020, at 5:49 PM, hubert depesz lubaczewski <depesz@depesz.com> wrote:
>
> On Tue, Sep 08, 2020 at 05:38:24PM +0800, ZongtianHou wrote:
>> I found dropped columns still exist in pg_attribute table. In the
>> below example I drop c2 column and vacuum (full) this table and
>> pg_attribute, it still exist (the last row). how can I clean it away?
>
> Unfortunately only by copying the table aside, and then renaming new
> table.
>
> But - the dropped attribute will not sure any disk space, as long as you
> ran some vacuums.
>
> Best regards,
>
> depesz
>