On Mon, 2022-01-24 at 08:08 -0800, Wells Oliver wrote: > > > I need only drop the column and VACUUM FULL the table, and not the entire DB, right? > > > > Not that VACUUM (FULL) will *not* physically get rid of a dropped column, > > as it just copies the complete rows to a new table. > > > > You would need something like: > > > > CREATE TABLE newtab (LIKE oldtab); > > INSERT INTO newtab SELECT * FROM oldtab; > > So, there's really no way to reclaim space from a dropped column other than > entirely creating a new table? Correct, as far as I know. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com
