Description of problem:
The 'critical updates available' report takes over 15 minutes to run with around 400 systems in a group.
This causes an ISE due to the query taking too long to return.
This is due to a correlated subquery in the "relevant_to_server_group" query.
Version-Release number of selected component (if applicable):
a. Click on 'Systems'.
b. Click on 'System Groups'.
c. Click on a Group Name that has over 300 entries
d. Click on 'critical updates available'
15+ minute query time
Query response in under 15 seconds
Reproducible on Oracle and PostgreSQL
Move Spacewalk 2.9 bugs ON_QA.
Spacewalk 2.9 has been released.