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
_______________________________________________ Mailing list: https://launchpad.net/~launchpad-reviewers Post to : launchpad-reviewers@lists.launchpad.net Unsubscribe : https://launchpad.net/~launchpad-reviewers More help : https://help.launchpad.net/ListHelp
