One giant UPDATE holds row locks and produces dead rows all at once. A loop that updates an id range per batch keeps each transaction small.
Backfill
Filling a new column for existing rows, in small batches so locks and transactions stay short.
One giant UPDATE holds row locks and produces dead rows all at once. A loop that updates an id range per batch keeps each transaction small.