Database goals for March 28th, 2018

@abrandl:

• Investigate what we can do about (issue dashboard times out) https://gitlab.com/gitlab-org/gitlab-ce/issues/44470
• Controller UsersController#show executes more than 100 SQL queries https://gitlab.com/gitlab-org/gitlab-ce/issues/43150

Picked up during the week:

• Remove unused index https://gitlab.com/gitlab-org/gitlab-ce/issues/44467

@_stark:

• gitlab-org/omnibus-gitlab!2332 (closed) (JSON plugin in omnibus)
  • Blocked on getting approval from Marin
  • Progress made, omnibus building our patched version of jsonlog with all tests passing: https://dev.gitlab.org/gitlab/omnibus-gitlab/pipelines/79608
  • Meeting with Marin scheduled regarding adding dependencies
  • Sent new PR to upstream https://github.com/michaelpq/pg_plugins/pull/22 we will be happy if that or https://github.com/michaelpq/pg_plugins/pull/21 is accepted
    • PR 22 was merged this morning!
• gitlab-com/migration#268 (closed) (GEO replication lag)
  • Identified slow queries causing replication conflicts
  • https://gitlab.com/gitlab-com/infrastructure/issues/3905 (set vacuum_defer_cleanup_age)

Other things that came up during the week:

• https://gitlab.com/gitlab-org/gitlab-ce/issues/43552
  • Reviewed https://gitlab.com/gitlab-org/gitlab-ce/merge_requests/17934
• https://gitlab.com/gitlab-org/gitlab-ee/issues/5424
  • Gave some feedback and gave action items to send back to user. Requested xlog files for further analysis.
• https://gitlab.com/gitlab-org/gitlab-ce/issues/44302#note_64006990
  • User feedback from earlier week. Sent some further feedback suggesting testing their system with pg_test_fsync
• https://gitlab.com/gitlab-org/gitlab-ce/merge_requests/17521
  • Reviewed again. Should be just about done
• Verify monkeypatch from Lin Jen-Shin https://gitlab.com/gitlab-org/gitlab-ce/issues/43710:

@yorickpeterse:

• Fix Alpine setup for chatops (e.g. https://gitlab.com/gitlab-com/chatops/-/jobs/58680853) so we can finally start using it
• gitlab-com/chatops#12 (closed): break up in smaller issues (not going to wait for a reply), carried over from March 21
• Review https://gitlab.com/gitlab-org/gitlab-ee/merge_requests/4549
• Finalize Q2 OKR: gitlab-com/www-gitlab-com#2008 (closed)
  • MR: gitlab-com/www-gitlab-com!10679 (merged)
• gitlab-com/chatops#17 (closed)
• https://gitlab.com/gitlab-org/gitlab-ee/issues/5383
  • https://gitlab.com/gitlab-org/gitlab-ee/merge_requests/5077
• https://gitlab.com/gitlab-com/infrastructure/issues/3910: adjust vacuuming so we can better deal with the increase in load until this issue is solved
• https://gitlab.com/gitlab-com/infrastructure/issues/3918: gitlab-com/www-gitlab-com!10683 (merged)
• Review https://gitlab.com/gitlab-org/gitlab-ce/merge_requests/9646
• gitlab-com/www-gitlab-com!10684 (merged)
• https://gitlab.com/gitlab-org/gitlab-ce/issues/43048
  • My current plan is to spend a day or two hacking on an experimental Markdown renderer serving as an alternative to the current one: https://gitlab.com/gitlab-org/gitlab-ce/issues/43048#note_65305139
• Review https://gitlab.com/gitlab-org/gitlab-ee/merge_requests/5103
• https://dev.gitlab.org/cookbooks/chef-repo/merge_requests/1729/diffs

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