Skip to content
Snippets Groups Projects

datastore: Revert use of materialized views (v14.4)

Revert the introduction of materialized views for valid_primaries. As it turns out, the changes cause incompatibilities with Postgres 11, which is still actively in use. Furthermore, the performance issues we have seen have not been fully fixed with this change, and we do not yet fully understand the root cause for this.

Fixes gitlab-com/gl-infra/production#5945 (closed)

Edited by Patrick Steinhardt

Merge request reports

Merge train pipeline #414545304 passed

Merge train pipeline passed for 7d869cbc

Test coverage 71.20% from 1 job
Approved by

Merged by Patrick SteinhardtPatrick Steinhardt 3 years ago (Nov 23, 2021 11:07am UTC)

Merge details

  • Changes merged into 14-4-stable with fe9eb6b4.
  • Deleted the source branch.
  • Auto-merge enabled

Activity

Filter activity
  • Approvals
  • Assignees & reviewers
  • Comments (from bots)
  • Comments (from users)
  • Commits & branches
  • Edits
  • Labels
  • Lock status
  • Mentions
  • Merge request status
  • Tracking
Please register or sign in to reply
Loading