| Index: trunk/phase3/maintenance/postgres/tables.sql |
| — | — | @@ -68,6 +68,7 @@ |
| 69 | 69 | CREATE INDEX page_user_title ON page (page_title) WHERE page_namespace = 2; |
| 70 | 70 | CREATE INDEX page_utalk_title ON page (page_title) WHERE page_namespace = 3; |
| 71 | 71 | CREATE INDEX page_project_title ON page (page_title) WHERE page_namespace = 4; |
| | 72 | +CREATE INDEX page_mediawiki_title ON page (page_title) WHERE page_namespace = 8; |
| 72 | 73 | CREATE INDEX page_random_idx ON page (page_random); |
| 73 | 74 | CREATE INDEX page_len_idx ON page (page_len); |
| 74 | 75 | |
| Index: trunk/phase3/maintenance/updaters.inc |
| — | — | @@ -1512,13 +1512,14 @@ |
| 1513 | 1513 | ); |
| 1514 | 1514 | |
| 1515 | 1515 | $newindexes = array( |
| 1516 | | - array( "archive", "archive_user_text", "(ar_user_text)" ), |
| 1517 | | - array( "image", "img_sha1", "(img_sha1)" ), |
| 1518 | | - array( "oldimage", "oi_sha1", "(oi_sha1)" ), |
| 1519 | | - array( "revision", "rev_text_id_idx", "(rev_text_id)" ), |
| 1520 | | - array( "recentchanges", "rc_timestamp_bot", "(rc_timestamp) WHERE rc_bot = 0" ), |
| 1521 | | - array( "templatelinks", "templatelinks_from", "(tl_from)" ), |
| 1522 | | - array( "watchlist", "wl_user", "(wl_user)" ), |
| | 1516 | + array( "archive", "archive_user_text", "(ar_user_text)" ), |
| | 1517 | + array( "image", "img_sha1", "(img_sha1)" ), |
| | 1518 | + array( "oldimage", "oi_sha1", "(oi_sha1)" ), |
| | 1519 | + array( "page", "page_mediawiki_title", "(page_title) WHERE page_namespace = 8" ), |
| | 1520 | + array( "revision", "rev_text_id_idx", "(rev_text_id)" ), |
| | 1521 | + array( "recentchanges", "rc_timestamp_bot", "(rc_timestamp) WHERE rc_bot = 0" ), |
| | 1522 | + array( "templatelinks", "templatelinks_from", "(tl_from)" ), |
| | 1523 | + array( "watchlist", "wl_user", "(wl_user)" ), |
| 1523 | 1524 | array( "logging", "logging_user_type_time", "(log_user, log_type, log_timestamp)" ), |
| 1524 | 1525 | array( "logging", "logging_page_id_time", "(log_page,log_timestamp)" ), |
| 1525 | 1526 | array( "iwlinks", "iwl_prefix_title_from", "(iwl_prefix, iwl_title, iwl_from)" ), |