|
7675.1086.1
by Robert Collins
Update bugtask heat indices. |
1 |
-- Copyright 2011 Canonical Ltd. This software is licensed under the
|
2 |
-- GNU Affero General Public License version 3 (see the file LICENSE).
|
|
3 |
||
4 |
SET client_min_messages=ERROR; |
|
5 |
||
6 |
-- Better indices from qa testing.
|
|
7 |
||
8 |
-- product context, id needed to override bitmap index plas.
|
|
9 |
CREATE INDEX bugtask__product__heat__id__idx ON bugtask USING btree (product, heat DESC, id) WHERE product IS NOT NULL; |
|
10 |
-- And just distribution
|
|
11 |
CREATE INDEX bugtask__distribution__heat__id__idx ON bugtask USING btree(distribution, heat DESC, id) WHERE distribution IS NOT NULL; |
|
12 |
||
13 |
INSERT INTO LaunchpadDatabaseRevision VALUES (2208, 59, 2); |