From ee57423144da2adcec117523bb9367d467d880ab Mon Sep 17 00:00:00 2001 From: Greg Sabino Mullane Date: Thu, 24 Jul 2008 22:28:29 +0000 Subject: [PATCH] Add partial index for common recentchanges query. --- maintenance/postgres/tables.sql | 1 + maintenance/updaters.inc | 9 +++++---- 2 files changed, 6 insertions(+), 4 deletions(-) diff --git a/maintenance/postgres/tables.sql b/maintenance/postgres/tables.sql index 40a948e2b3..b86b87bc7b 100644 --- a/maintenance/postgres/tables.sql +++ b/maintenance/postgres/tables.sql @@ -351,6 +351,7 @@ CREATE TABLE recentchanges ( rc_params TEXT ); CREATE INDEX rc_timestamp ON recentchanges (rc_timestamp); +CREATE INDEX rc_timestamp ON recentchanges (rc_timestamp) WHERE rc_bot = '0'; CREATE INDEX rc_namespace_title ON recentchanges (rc_namespace, rc_title); CREATE INDEX rc_cur_id ON recentchanges (rc_cur_id); CREATE INDEX new_name_timestamp ON recentchanges (rc_new, rc_namespace, rc_timestamp); diff --git a/maintenance/updaters.inc b/maintenance/updaters.inc index 67680c496b..b121f2f263 100644 --- a/maintenance/updaters.inc +++ b/maintenance/updaters.inc @@ -1515,10 +1515,11 @@ 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("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_nobot", "(rc_timestamp) WHERE rc_bot = 0"), ); $newrules = array( -- 2.20.1