summaryrefslogtreecommitdiff
path: root/lib/gitlab/background_migration/remove_restricted_todos.rb
Commit message (Collapse)AuthorAgeFilesLines
* Fix statement timeouts in RemoveRestrictedTodos migrationStan Hu2018-11-041-1/+1
| | | | | | | | | | | | | | On GitLab.com, the RemoveRestrictedTodos background migration encountered about 700+ failures a day due to statement timeouts. PostgreSQL might perform badly with a LIMIT 1 because the planner is guessing that scanning the index in ID order will come across the desired row in less time it will take the planner than using another index. The order_hint does not affect the search results. For example, `ORDER BY id ASC, updated_at ASC` means the same thing as `ORDER BY id ASC`. Closes https://gitlab.com/gitlab-org/gitlab-ce/issues/52649
* Use a CTE to remove the query timeoutBrett Walker2018-10-051-9/+75
|
* Remove todos of users without access to targets migrationJarka Kadlecová2018-08-071-0/+105