Have a process to ensure squashing DB migrations are done regularly

Context

In Investigate db:check-schema slowdown (#564 - closed), we noticed that the DB migrations weren't squashed for a year.

Improve migration squash tooling (gitlab-org/gitlab#498538 - closed) should greatly simplify the DB migrations squashing process. We would still need to ensure this process is done regularly (ideally by groupdatabase).

Goal(s)

  • Have a process we could follow in Engineering Productivity to ping the DRIs to squash DB migrations (or, if the process really is straightforward, just do it ourselves on a regular basis).
  • Ensure the process to do generate a squashing MR is documented (even if it ends up being a one-liner like "MRs are generated automatically every X months, and are assigned to groupdatabase for review"

Things to figure out

  • Smallest interval at which we could safely squash DB migrations (every release, every 3 releases, ...). The smaller the number of migrations, the better.
Edited by David Dieulivol