r80571 MediaWiki - Code Review archive

Repository:MediaWiki
Revision:< r80570‎ | r80571 | r80572 >
Date:16:14, 19 January 2011
Author:greg
Status:ok
Tags:
Comment:
Use text_pattern_ops for page_title, as some code uses 'anchor%' matching.
Modified paths:
  • /trunk/phase3/maintenance/postgres/tables.sql (modified) (history)

Diff [purge]

Index: trunk/phase3/maintenance/postgres/tables.sql
——@@ -63,12 +63,12 @@
6464 page_len INTEGER NOT NULL
6565 );
6666 CREATE UNIQUE INDEX page_unique_name ON page (page_namespace, page_title);
67 -CREATE INDEX page_main_title ON page (page_title) WHERE page_namespace = 0;
68 -CREATE INDEX page_talk_title ON page (page_title) WHERE page_namespace = 1;
69 -CREATE INDEX page_user_title ON page (page_title) WHERE page_namespace = 2;
70 -CREATE INDEX page_utalk_title ON page (page_title) WHERE page_namespace = 3;
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;
 67+CREATE INDEX page_main_title ON page (page_title text_pattern_ops) WHERE page_namespace = 0;
 68+CREATE INDEX page_talk_title ON page (page_title text_pattern_ops) WHERE page_namespace = 1;
 69+CREATE INDEX page_user_title ON page (page_title text_pattern_ops) WHERE page_namespace = 2;
 70+CREATE INDEX page_utalk_title ON page (page_title text_pattern_ops) WHERE page_namespace = 3;
 71+CREATE INDEX page_project_title ON page (page_title text_pattern_ops) WHERE page_namespace = 4;
 72+CREATE INDEX page_mediawiki_title ON page (page_title text_pattern_ops) WHERE page_namespace = 8;
7373 CREATE INDEX page_random_idx ON page (page_random);
7474 CREATE INDEX page_len_idx ON page (page_len);
7575

Status & tagging log