Re: how to clean dropped column in pg_attribute - Mailing list pgsql-admin

From hubert depesz lubaczewski
Subject Re: how to clean dropped column in pg_attribute
Date
Msg-id 20200908094917.GA11563@depesz.com
Whole thread Raw
In response to how to clean dropped column in pg_attribute  (ZongtianHou <zongtianhou@icloud.com>)
Responses Re: how to clean dropped column in pg_attribute  (ZongtianHou <zongtianhou@icloud.com>)
List pgsql-admin
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




pgsql-admin by date:

Previous
From: ZongtianHou
Date:
Subject: how to clean dropped column in pg_attribute
Next
From: ZongtianHou
Date:
Subject: Re: how to clean dropped column in pg_attribute