Update the column to NULL to reduce its size, then vacuum the table to reclaim space, Copy the data to a new table without the column, then replace the old table - if your using version 13 or later-- you can try ALTER TABLE a DROP COLUMN b;try Use pg_repack (optional)