| Index: trunk/phase3/maintenance/postgres/tables.sql |
| — | — | @@ -365,8 +365,8 @@ |
| 366 | 366 | wl_notificationtimestamp TIMESTAMPTZ |
| 367 | 367 | ); |
| 368 | 368 | CREATE UNIQUE INDEX wl_user_namespace_title ON watchlist (wl_namespace, wl_title, wl_user); |
| | 369 | +CREATE INDEX wl_user ON watchlist (wl_user); |
| 369 | 370 | |
| 370 | | - |
| 371 | 371 | CREATE TABLE math ( |
| 372 | 372 | math_inputhash BYTEA NOT NULL UNIQUE, |
| 373 | 373 | math_outputhash BYTEA NOT NULL, |
| Index: trunk/phase3/maintenance/updaters.inc |
| — | — | @@ -1520,6 +1520,7 @@ |
| 1521 | 1521 | array("oldimage", "oi_sha1", "(oi_sha1)"), |
| 1522 | 1522 | array("revision", "rev_text_id_idx", "(rev_text_id)"), |
| 1523 | 1523 | array("recentchanges", "rc_timestamp_nobot", "(rc_timestamp) WHERE rc_bot = 0"), |
| | 1524 | + array("watchlist", "wl_user", "(wl_user)"), |
| 1524 | 1525 | ); |
| 1525 | 1526 | |
| 1526 | 1527 | $newrules = array( |