Backfill

Populating a new field or table for existing data, usually in batches with a delay between them. Doing it in one statement takes a long lock and a large amount of replication lag with it. The batch job also has to handle rows written after it started, which is why backfills are normally paired with dual writes.