Database goals for October 11th, 2017

@yorickpeterse:

Take over the following issues (scheduled for 10.2 but I can easily do them for 10.1):

• https://gitlab.com/gitlab-org/gitlab-ce/issues/38509: didn't get to this
• https://gitlab.com/gitlab-org/gitlab-ce/issues/38510: can't be fixed, see comments in issue
• https://gitlab.com/gitlab-org/gitlab-ce/issues/38621: so I can start importing my GitHub projects
  • Work in progress MR: https://gitlab.com/gitlab-org/gitlab-ce/merge_requests/14731

@_stark:

Database reconcilation:

• https://gitlab.com/gitlab-org/gitlab-ce/merge_requests/14381: test impact of many ALTER TABLE in production using special purpose script
• https://gitlab.com/gitlab-org/gitlab-ce/issues/38726: investigate cause of missing/extra NOT NULL constraints
• https://gitlab.com/gitlab-org/gitlab-ce/issues/38725: investigate cause of missing/extra indexes

Other tasks:

• Added: Add Pull Mirror SLA metrics for Tiago, Douwe,Pablo
• Prepare MR for new prometheus alert based on new postgres stats
  • Perhaps "new slowest query" or "new query consuming excessive i/o"
  • gitlab-com/runbooks!378 (merged)
  • gitlab-com/runbooks!379 (closed)
• Write document Discuss with developers proposed direction to make queries from ruby controllers scalable -- what kinds of application functionality may need to be compromised
  • Discussed with Douwe and Zj in Amsterdam, winning hearts and minds :)
• May need some followup for https://gitlab.zendesk.com/agent/tickets/82768--
  • No news is good news?

Last week's goals: https://gitlab.com/gitlab-com/infrastructure/issues/2873