Database goals for May 21st, 2018

@abrandl:

• Holidays on May 14th and 18th
• Find co-working space

Status for these items: In review / ready to merge

• Keyset pagination: https://gitlab.com/gitlab-org/gitlab-ce/merge_requests/18584
• Composite primary keys for PG only: https://gitlab.com/gitlab-org/gitlab-ce/issues/43706
• Schema cleanup for project_authorizations https://gitlab.com/gitlab-org/gitlab-ce/issues/32258

@yorickpeterse:

General goals:

• https://gitlab.com/gitlab-org/gitlab-ce/issues/43048: see what remains to be done here
  • WIP MR: https://gitlab.com/gitlab-org/gitlab-ce/merge_requests/18973
  • Made progress, but ended up spending more time looking into our performance degradation, and working on the DB load balancer. Hopefully I will be able to finish this over the course of next week.
• https://gitlab.com/gitlab-org/gitlab-ce/merge_requests/18427: respond to feedback, if any
• Keep an eye on https://gitlab.com/gitlab-com/people-ops/General/issues/113: ongoing

Monday:

• Review Lever candidate for the DB manager position
• Start looking into https://gitlab.com/gitlab-org/gitlab-ce/issues/43048
• Increase threshold for deadlocking alert: it's not really actionable, but still useful to have: runbooks@e9e07106
• #76 (closed)
• Review https://gitlab.com/gitlab-org/gitlab-ce/merge_requests/18925
• #55 (closed): runbooks@061873bd

Tuesday:

• Look into https://gitlab.com/gitlab-com/infrastructure/issues/3499. Controllers getting mixed up makes it really hard to figure out what is really to blame for something being slow.
  • MR: https://gitlab.com/gitlab-org/gitlab-ce/merge_requests/18975
• Review migration!16 (merged)
• Review https://gitlab.com/gitlab-org/gitlab-ce/merge_requests/18553
• Distracted for a bit with the performance degradation of the past few days

Wednesday:

• https://gitlab.com/gitlab-org/gitlab-ce/issues/46412
• https://gitlab.com/gitlab-org/gitlab-ee/issues/6041
  • MR: https://gitlab.com/gitlab-org/gitlab-ee/merge_requests/5732
• Review https://gitlab.com/gitlab-org/gitlab-ee/merge_requests/5733
• Review https://gitlab.com/gitlab-org/gitlab-ce/merge_requests/18982

Thursday:

• Review https://gitlab.com/gitlab-org/gitlab-ce/merge_requests/18584
• Respond to feedback on https://gitlab.com/gitlab-org/gitlab-ce/merge_requests/18427
• https://gitlab.com/gitlab-com/infrastructure/issues/4231
• https://gitlab.com/gitlab-com/infrastructure/issues/4207#note_73557833
• https://hire.lever.co/candidates/b11692fe-f229-48b3-8914-7f851c4cb895
• https://hire.lever.co/candidates/c814d7a0-bfc6-4038-a8b5-254985753783

Friday:

• Review https://gitlab.com/gitlab-org/gitlab-ce/merge_requests/18980
• Review https://gitlab.com/gitlab-org/gitlab-ce/merge_requests/18557
• https://gitlab.com/gitlab-org/gitlab-ce/merge_requests/19021
• Apply https://gitlab.com/gitlab-org/gitlab-ee/merge_requests/5755 to production (by reverting the patches in the post-deployment patches repository)

Last week's goals: #78 (closed)