From f6e216c54ee375c0b0ca35054be7f9d7dcb58a00 Mon Sep 17 00:00:00 2001 From: Greg Sabino Mullane Date: Wed, 4 Aug 2010 12:40:42 +0000 Subject: [PATCH] Add new partial index for Postgres --- maintenance/postgres/tables.sql | 1 + maintenance/updaters.inc | 15 ++++++++------- 2 files changed, 9 insertions(+), 7 deletions(-) diff --git a/maintenance/postgres/tables.sql b/maintenance/postgres/tables.sql index 47b17a8e99..60d0413f52 100644 --- a/maintenance/postgres/tables.sql +++ b/maintenance/postgres/tables.sql @@ -68,6 +68,7 @@ CREATE INDEX page_talk_title ON page (page_title) WHERE page_namespace = CREATE INDEX page_user_title ON page (page_title) WHERE page_namespace = 2; CREATE INDEX page_utalk_title ON page (page_title) WHERE page_namespace = 3; CREATE INDEX page_project_title ON page (page_title) WHERE page_namespace = 4; +CREATE INDEX page_mediawiki_title ON page (page_title) WHERE page_namespace = 8; CREATE INDEX page_random_idx ON page (page_random); CREATE INDEX page_len_idx ON page (page_len); diff --git a/maintenance/updaters.inc b/maintenance/updaters.inc index fc92e84294..a5e3fdcc72 100644 --- a/maintenance/updaters.inc +++ b/maintenance/updaters.inc @@ -1512,13 +1512,14 @@ function do_postgres_updates() { ); $newindexes = array( - array( "archive", "archive_user_text", "(ar_user_text)" ), - array( "image", "img_sha1", "(img_sha1)" ), - array( "oldimage", "oi_sha1", "(oi_sha1)" ), - array( "revision", "rev_text_id_idx", "(rev_text_id)" ), - array( "recentchanges", "rc_timestamp_bot", "(rc_timestamp) WHERE rc_bot = 0" ), - array( "templatelinks", "templatelinks_from", "(tl_from)" ), - array( "watchlist", "wl_user", "(wl_user)" ), + array( "archive", "archive_user_text", "(ar_user_text)" ), + array( "image", "img_sha1", "(img_sha1)" ), + array( "oldimage", "oi_sha1", "(oi_sha1)" ), + array( "page", "page_mediawiki_title", "(page_title) WHERE page_namespace = 8" ), + array( "revision", "rev_text_id_idx", "(rev_text_id)" ), + array( "recentchanges", "rc_timestamp_bot", "(rc_timestamp) WHERE rc_bot = 0" ), + array( "templatelinks", "templatelinks_from", "(tl_from)" ), + array( "watchlist", "wl_user", "(wl_user)" ), array( "logging", "logging_user_type_time", "(log_user, log_type, log_timestamp)" ), array( "logging", "logging_page_id_time", "(log_page,log_timestamp)" ), array( "iwlinks", "iwl_prefix_title_from", "(iwl_prefix, iwl_title, iwl_from)" ), -- 2.20.1