| Index: trunk/phase3/maintenance/postgres/tables.sql |
| — | — | @@ -169,6 +169,7 @@ |
| 170 | 170 | pl_title TEXT NOT NULL |
| 171 | 171 | ); |
| 172 | 172 | CREATE UNIQUE INDEX pagelink_unique ON pagelinks (pl_from,pl_namespace,pl_title); |
| | 173 | +CREATE INDEX pagelinks_title ON pagelinks (pl_title); |
| 173 | 174 | |
| 174 | 175 | CREATE TABLE templatelinks ( |
| 175 | 176 | tl_from INTEGER NOT NULL REFERENCES page(page_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED, |
| Index: trunk/phase3/includes/installer/PostgresUpdater.php |
| — | — | @@ -173,6 +173,7 @@ |
| 174 | 174 | array( 'addPgIndex', 'image', 'img_sha1', '(img_sha1)' ), |
| 175 | 175 | array( 'addPgIndex', 'oldimage', 'oi_sha1', '(oi_sha1)' ), |
| 176 | 176 | array( 'addPgIndex', 'page', 'page_mediawiki_title', '(page_title) WHERE page_namespace = 8' ), |
| | 177 | + array( 'addPgIndex', 'pagelinks', 'pagelinks_title', '(pl_title)' ), |
| 177 | 178 | array( 'addPgIndex', 'revision', 'rev_text_id_idx', '(rev_text_id)' ), |
| 178 | 179 | array( 'addPgIndex', 'recentchanges', 'rc_timestamp_bot', '(rc_timestamp) WHERE rc_bot = 0' ), |
| 179 | 180 | array( 'addPgIndex', 'templatelinks', 'templatelinks_from', '(tl_from)' ), |