Database goals for July 5th, 2017

Goals for July 5th

@yorickpeterse:

• Fix failing tests for EE foreign keys: https://gitlab.com/gitlab-org/gitlab-ee/merge_requests/2223
• Add support for querying events including push events: https://gitlab.com/gitlab-org/gitlab-ce/merge_requests/12463: ongoing process, did not manage to complete this before today
• https://gitlab.com/gitlab-com/infrastructure/issues/2140
  • MR gitlab-com/www-gitlab-com!6660 (merged)
• https://gitlab.com/gitlab-org/gitlab-ce/issues/33726

Last Week's Goals

Since this is the first week we'll be using issues for this I just copied last week's goals from the Google document/agenda

@yorickpeterse:

1. Come up with a final solution for refactoring events queries so they’re not dog slow (part of https://gitlab.com/gitlab-org/gitlab-ce/issues/31806).

• Status: first build the new table setup, then optimise the queries using LATERAL JOIN as proposed by the DB consultant

1. Get my foreign key fixes (https://gitlab.com/gitlab-org/gitlab-ce/merge_requests/9388) merged in once https://gitlab.com/gitlab-org/gitlab-ee/merge_requests/2056 is merged (so I can do the EE side without 5 million conflicts)

• Status: didn’t get to this this week due to deployment problems of 9.3 and “events” work taking up most time

1. Plan the upgrade to PostgreSQL 9.6.3: https://gitlab.com/gitlab-com/infrastructure/issues/1158 / https://gitlab.com/gitlab-com/infrastructure/issues/1158#note_33122221

• Status: repmgr is apparently already in 9.3, with more planned for 9.4 I believe. The plan is to get this working first, then do an upgrade using a failover: https://gitlab.com/gitlab-com/infrastructure/issues/1158#note_33192390 and later comments

1. Start working on the events database migration for https://gitlab.com/gitlab-org/gitlab-ce/issues/31806

• Status: WIP MR is at https://gitlab.com/gitlab-org/gitlab-ce/merge_requests/12463, including the migrations/tables.