| |
@@ -238,6 +238,7 @@
|
| |
CREATE INDEX task_by_state ON task (state);
|
| |
-- CREATE INDEX task_by_parent ON task (parent); (unique condition creates similar index)
|
| |
CREATE INDEX task_by_host ON task (host_id);
|
| |
+ CREATE INDEX task_by_no_parent_state_method ON task(parent, state, method) WHERE parent IS NULL;
|
| |
|
| |
|
| |
-- by package, we mean srpm
|
| |
Fixes: https://pagure.io/koji/issue/2418