Re: How to reclaim the space of dropped columns of a table?

2019-07-15 Thread Tom Lane
"David G. Johnston" writes: > On Mon, Jul 15, 2019 at 8:42 AM Paul Guo wrote: >> This seems to a bit vague for users (how to rewrite but keep the table >> definition) and it seems to still keep the dropped columns (though with >> null). Isn't it better to leave the functionality to command like

Re: How to reclaim the space of dropped columns of a table?

2019-07-15 Thread David G. Johnston
On Mon, Jul 15, 2019 at 8:42 AM Paul Guo wrote: > This seems to a bit vague for users (how to rewrite but keep the table > definition) and it seems to still keep the dropped columns (though with > null). Isn't it better to leave the functionality to command like 'vacuum > full' to completely

How to reclaim the space of dropped columns of a table?

2019-07-15 Thread Paul Guo
Hello hackers, I have been having a question about this with no answer from various sources . As known after dropping a column using 'alter table', table is not rewritten and vacuum full does not remove them also (still see the dropped column in pg_attribute). PG document says: