From f8ef51fc11a4e397d36a999b23dbf760dd9749cd Mon Sep 17 00:00:00 2001 From: Greg Sabino Mullane Date: Thu, 31 Jul 2008 16:18:59 +0000 Subject: [PATCH] Add separate index for watchlist(wl_user) [Postgres] --- maintenance/postgres/tables.sql | 2 +- maintenance/updaters.inc | 1 + 2 files changed, 2 insertions(+), 1 deletion(-) diff --git a/maintenance/postgres/tables.sql b/maintenance/postgres/tables.sql index b86b87bc7b..8dbf77fa01 100644 --- a/maintenance/postgres/tables.sql +++ b/maintenance/postgres/tables.sql @@ -365,7 +365,7 @@ CREATE TABLE watchlist ( wl_notificationtimestamp TIMESTAMPTZ ); CREATE UNIQUE INDEX wl_user_namespace_title ON watchlist (wl_namespace, wl_title, wl_user); - +CREATE INDEX wl_user ON watchlist (wl_user); CREATE TABLE math ( math_inputhash BYTEA NOT NULL UNIQUE, diff --git a/maintenance/updaters.inc b/maintenance/updaters.inc index b121f2f263..19687b2b31 100644 --- a/maintenance/updaters.inc +++ b/maintenance/updaters.inc @@ -1520,6 +1520,7 @@ function do_postgres_updates() { 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"), + array("watchlist", "wl_user", "(wl_user)"), ); $newrules = array( -- 2.20.1