Ok, thanks for this info Best regards, Zongtian > On Sep 8, 2020, at 5:49 PM, hubert depesz lubaczewski <depesz@xxxxxxxxxx> 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 >
