Skip to content

Fully shard merge_request_cleanup_schedules

MergeRequestCleanupSchedules (# rows: https://postgres.ai/console/gitlab/gitlab-production-main/sessions/41965/commands/128841)

Milestone 18.3

  • add a NOT NULL (NOT VALID) constraint on sharding key for new records -> !199935 (merged)

Milestone 18.4

Milestone 18.5 (required stop)

Milestone 18.6

  • Prepare to fully shard table -> !209477 (merged)
    • finalize sharding key backfill
    • prepare ASYNC constraint check on NOT NULL sharding key
  • Verify the NOT NULL (NOT VALID) -> NOT NULL constraint has changed on the sharding key on .com
  • Fully shard table ->
    • SYNC validate NOT NULL constraint on sharding key
    • update db/docs/*.yml with sharding key
  • verify the NOT NULL constraint check is set on the table's sharding key
Edited by Tomasz Skorupa