News for hackers. Stuff that matters.

A comment on Pgroll: zero-downtime, undoable, schema migrations for Postgres. Parent comment

Re:Pgroll: zero-downtime, undoable, schema migrations for Po... by pcthrowaway on Tuesday October 03, 2023 @04:16PM (#37756971)
Also, if the data isn't deleted couldn't this lead to database bloat?
[ Parent | on HN ]
Re:Pgroll: zero-downtime, undoable, schema migrations for Po... by surjection on Tuesday October 03, 2023 @04:51PM (#37757395)
The bloat incurred by the extra column is certainly present while the migration is in progress (ie after it's been started with `pgroll start` but before running `pgroll complete`).

Once the migration is completed any extra columns are dropped.

[ Parent | on HN ]