Re: how to clean dropped column in pg_attribute

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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






[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux