Skip to content

Backfill namespace_id in issue_search_data

Heinrich Lee Yu requested to merge 393126-populate-namespace-id-issue-search-data into master

What does this MR do and why?

Backfill namespace_id for issue_search_data

We will use this column as the new partitioning key.

Related to #393126 (closed)

Records that need to be updated:

gitlabhq_dblab=# SELECT COUNT(*) FROM issue_search_data WHERE namespace_id IS NULL;
  count
----------
 81281396
(1 row)

MR acceptance checklist

This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.

Edited by Heinrich Lee Yu

Merge request reports