Skip to content

Remove import columns from projects table

Stan Hu requested to merge sh-remove-import-columns-from-projects into master

In https://gitlab.com/gitlab-org/gitlab-ce/merge_requests/21497, we migrated all project import data into a separate table, "project_import_data". In addition, we also added:

  ignore_column :import_status, :import_jid, :import_error

In gitlab-com/gl-infra/production#908 (closed), we observed some of these import_error columns consumed megabytes of error backtraces and caused slow loading of projects whenever a SELECT * from projects query loaded the row into memory.

Since we have migrated from using these columns long ago, we can now drop these columns entirely.

EE port: https://gitlab.com/gitlab-org/gitlab-ee/merge_requests/14288

Edited by Stan Hu

Merge request reports