Re:Pgroll: zero-downtime, undoable, schema migrations for Po...
by pritambaral on Tuesday October 03, 2023 @01:18PM
(#37754806)
> ... so there there is no bloat left behind after the migration is done.
This is only true after all rows are rewritten after the old column is dropped. In standard, unmodified Postgres, DROP COLUMN does not rewrite existing tuples.
This is only true after all rows are rewritten after the old column is dropped. In standard, unmodified Postgres, DROP COLUMN does not rewrite existing tuples.