7675.827.1
by Robert Collins
Improve performance of bug searches ordered by importance. |
1 |
SET client_min_messages=ERROR; |
2 |
||
3 |
-- Permit bug searches ordered by 'importance' - the default - to serve from
|
|
4 |
-- index rather than doing the full search and sorting.
|
|
5 |
||
6 |
CREATE INDEX bugtask_importance_idx ON BugTask (importance, id desc nulls first); |
|
7 |
||
7675.827.2
by Robert Collins
Assign final patch number. |
8 |
INSERT INTO LaunchpadDatabaseRevision VALUES (2208, 8, 2); |