Project

General

Profile

Bug #22111

add taxonomies index to hosts table

Added by Tomer Brisker almost 3 years ago. Updated over 2 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Tomer Brisker
Category:
Database
Target version:
1.17.0
Difficulty:
Triaged:
Bugzilla link:
Pull request:
https://github.com/theforeman/foreman/pull/5140
Fixed in Releases:
Found in Releases:

Description

a lot of queries filter hosts by current context. when there are many hosts, this sequential scan can take relatively long.

Associated revisions

Revision 452a0264 (diff)
Added by Tomer Brisker almost 3 years ago

Fixes #22111 - add taxonomy indexes to hosts

History

#1 Updated by The Foreman Bot almost 3 years ago

  • Status changed from New to Ready For Testing
  • Pull request https://github.com/theforeman/foreman/pull/5140 added

#2 Updated by Timo Goebel almost 3 years ago

  • Legacy Backlogs Release (now unused) set to 296

#3 Updated by Anonymous almost 3 years ago

  • % Done changed from 0 to 100
  • Status changed from Ready For Testing to Closed

Also available in: Atom PDF