ملء البيانات القديمة على دفعات

في هذا الدرس

populate a new column on a huge table safely.

الموضوعات المخطط لها

• One giant UPDATE holds locks, creates huge WAL and bloat, and can run for hours.
• Update in small batches (1 000–10 000 rows) by primary key range, each in its own transaction, with a short pause.
• Make the job resumable and idempotent (WHERE full_name IS NULL).
• Watch replication lag and load; throttle if needed.
• Run backfills from an operational job, not inside the startup migration.