Tasks

A change to make, a table with forty-one million rows in it, and a workload that does not stop while you make it. Graded on the end schema, the seconds writes were blocked, whether a row went missing, and whether the old code kept working.

• Rewrite or metadata

  • Add a column nobody noticeswarm-up4 min
  • Give it a default without a rewritewarm-up5 min
  • The one you cannot make cheaproutine6 min

• Indexes

  • Index a live tableroutine6 min
  • Drop the index nobody useswarm-up4 min
  • Ship it with a way backroutine7 min

• Constraints

  • Make a column NOT NULL without the scanhard12 min
  • Add a foreign key to a live pair of tablesroutine8 min

• Expand and contract

  • Rename a column the old deploy is still readinghard12 min

• Backfills

  • Fill ten million rows without a wall of errorsroutine8 min