launchpad-reviewers team mailing list archive

[Alvaro Crespo Serrano <mp+485272@xxxxxxxxxxxxxxxxxx>]

Alvaro Crespo Serrano has proposed merging ~alvarocs/launchpad:db-live-creation-index-craft-platforms into launchpad:master.

Commit message:
2211-33-2: creation of indexes for craft_platform column in craft tables

Requested reviews:
  Launchpad code reviewers (launchpad-reviewers)

For more details, see:
https://code.launchpad.net/~alvarocs/launchpad/+git/launchpad/+merge/485272

Creation of indexes for 'craft_platform' column in CharmRecipeBuild, RockRecipeBuild, SnapBuild and CraftRecipeBuild. Done after patches 2211-33-0 and -1 which add the column to those tables.
https://wiki.canonical.com/InformationInfrastructure/OSA/RequestLogging/LP/SQL

-- 
Your team Launchpad code reviewers is requested to review the proposed merge of ~alvarocs/launchpad:db-live-creation-index-craft-platforms into launchpad:master.

diff --git a/database/schema/patch-2211-33-2.sql b/database/schema/patch-2211-33-2.sql
new file mode 100644
index 0000000..f10406e
--- /dev/null
+++ b/database/schema/patch-2211-33-2.sql
@@ -0,0 +1,15 @@
+-- Copyright 2025 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 CONCURRENTLY charmrecipebuild__craft_platform__idx
+    ON CharmRecipeBuild (craft_platform);
+CREATE INDEX CONCURRENTLY rockrecipebuild__craft_platform__idx
+    ON RockRecipeBuild (craft_platform);
+CREATE INDEX CONCURRENTLY snapbuild__craft_platform__idx
+    ON SnapBuild (craft_platform);
+CREATE INDEX CONCURRENTLY craftrecipebuild__craft_platform__idx
+    ON CraftRecipeBuild (craft_platform);
+
+INSERT INTO LaunchpadDatabaseRevision VALUES (2211, 33, 2);
\ No newline at end of file