Launchpad itself

Merge lp:~wallyworld/launchpad/report-cache-index-1071581 into lp:launchpad

  1. report-cache-index-1071581
  2. Merge into devel
Proposed by Ian Booth
Status: Merged
Approved by: William Grant
Approved revision: no longer in the source branch.
Merged at revision: 16267
Proposed branch: lp:~wallyworld/launchpad/report-cache-index-1071581
Merge into: lp:launchpad
Diff against target: 14 lines (+10/-0)
1 file modified
database/schema/patch-2209-38-2.sql (+10/-0)
To merge this branch: bzr merge lp:~wallyworld/launchpad/report-cache-index-1071581
Reviewer Review Type Date Requested Status
William Grant db Approve
Review via email: mp+134274@code.launchpad.net

Commit message

Add new index to latestpersonsourcepackagereleasecache.

Description of the change

Add new index to latestpersonsourcepackagereleasecache -
(upload_archive, upload_distroseries, sourcepackagename)

To post a comment you must log in.
Revision history for this message
William Grant (wgrant) :
review: Approve (db)

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
1=== added file 'database/schema/patch-2209-38-2.sql'
2--- database/schema/patch-2209-38-2.sql 1970-01-01 00:00:00 +0000
3+++ database/schema/patch-2209-38-2.sql 2012-11-14 10:23:22 +0000
4@@ -0,0 +1,10 @@
5+-- Copyright 2012 Canonical Ltd. This software is licensed under the
6+-- GNU Affero General Public License version 3 (see the file LICENSE).
7+
8+SET client_min_messages=ERROR;
9+
10+CREATE INDEX latestpersonsourcepackagereleasecache__archive__distroseries__spn__idx
11+ ON latestpersonsourcepackagereleasecache (upload_archive, upload_distroseries, sourcepackagename);
12+
13+
14+INSERT INTO LaunchpadDatabaseRevision VALUES (2209, 38, 2);