Self hosting is never easy. If you nerf the GitLab database by doing something unsupported or because of a bug, good luck with that.

Source: an employer of mine nerfed the GitLab database and support to fix it was not an option, so we had to migrate to their cloud offering.