William Grant has proposed merging lp:~wgrant/launchpad/bfj-status-id-idx into lp:launchpad.
Commit message: Index BuildFarmJob(status, id) for retry-depwait's benefit. Requested reviews: Stuart Bishop (stub): db For more details, see: https://code.launchpad.net/~wgrant/launchpad/bfj-status-id-idx/+merge/128849 My retry-depwait rewrite in https://code.launchpad.net/~wgrant/launchpad/reretrydepwait/+merge/128688 needs a BuildFarmJob(status, id) index to be efficient. This is it. We might want to drop the BuildFarmJob(status) index eventually, but it's not a significant concern right no. -- https://code.launchpad.net/~wgrant/launchpad/bfj-status-id-idx/+merge/128849 Your team Launchpad code reviewers is subscribed to branch lp:launchpad.
=== added file 'database/schema/patch-2209-23-5.sql' --- database/schema/patch-2209-23-5.sql 1970-01-01 00:00:00 +0000 +++ database/schema/patch-2209-23-5.sql 2012-10-10 02:30:27 +0000 @@ -0,0 +1,8 @@ +-- Copyright 2012 Canonical Ltd. This software is licensed under the +-- GNU Affero General Public License version 3 (see the file LICENSE). + +SET client_min_messages=ERROR; + +CREATE INDEX buildfarmjob__status__id__idx ON buildfarmjob (status, id); + +INSERT INTO LaunchpadDatabaseRevision VALUES (2209, 23, 5);
_______________________________________________ Mailing list: https://launchpad.net/~launchpad-reviewers Post to : [email protected] Unsubscribe : https://launchpad.net/~launchpad-reviewers More help : https://help.launchpad.net/ListHelp
