Project

General

Profile

Bug #30103

Add index on locks for resource type and task id

Added by Tomer Brisker 3 months ago. Updated 3 months ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
Foreman plugin
Target version:
-

Description

https://community.theforeman.org/t/slow-products-page-on-2-0/19142/23 has indicated adding this index can lead to significant speed up of products page queries/

Associated revisions

Revision fb70a553 (diff)
Added by Tomer Brisker 3 months ago

Fixes #30103 - Add index to tasks_locks table

This index leads to significant improvement in speed of certain queries
looking for locks related to a specific task and resource type.
Also removes several indexes that are already covered by other
multi-column indexes.

History

#1 Updated by The Foreman Bot 3 months ago

  • Assignee set to Tomer Brisker
  • Status changed from New to Ready For Testing
  • Pull request https://github.com/theforeman/foreman-tasks/pull/557 added

#2 Updated by Tomer Brisker 3 months ago

  • Bugzilla link set to 1846313

#3 Updated by The Foreman Bot 3 months ago

  • Fixed in Releases foreman-tasks-2.0.1 added

#4 Updated by Anonymous 3 months ago

  • Status changed from Ready For Testing to Closed

#5 Updated by The Foreman Bot 3 months ago

  • Pull request https://github.com/theforeman/foreman-tasks/pull/565 added

#6 Updated by Adam Ruzicka 3 months ago

  • Fixed in Releases foreman-tasks-1.1.2 added

Also available in: Atom PDF