From 48df6bc4ee8c2fbef7fd5438771e76d032465a3d Mon Sep 17 00:00:00 2001 From: Greg Sabino Mullane Date: Mon, 15 Jan 2007 22:49:51 +0000 Subject: [PATCH] Add index on rev_text_id to help speed up full text searches. --- maintenance/postgres/tables.sql | 1 + maintenance/updaters.inc | 3 +++ 2 files changed, 4 insertions(+) diff --git a/maintenance/postgres/tables.sql b/maintenance/postgres/tables.sql index 8126ceb7cf..b2e659cda1 100644 --- a/maintenance/postgres/tables.sql +++ b/maintenance/postgres/tables.sql @@ -95,6 +95,7 @@ CREATE TABLE revision ( rev_deleted CHAR NOT NULL DEFAULT '0' ); CREATE UNIQUE INDEX revision_unique ON revision (rev_page, rev_id); +CREATE INDEX rev_text_id_idx ON revision (rev_text_id); CREATE INDEX rev_timestamp_idx ON revision (rev_timestamp); CREATE INDEX rev_user_idx ON revision (rev_user); CREATE INDEX rev_user_text_idx ON revision (rev_user_text); diff --git a/maintenance/updaters.inc b/maintenance/updaters.inc index e792143a9d..d330d755b3 100644 --- a/maintenance/updaters.inc +++ b/maintenance/updaters.inc @@ -1203,6 +1203,9 @@ CREATE TABLE page_restrictions ( ); ALTER TABLE page_restrictions ADD CONSTRAINT page_restrictions_pk PRIMARY KEY (pr_page,pr_type); +-- Add a new index to help with full-text searches +CREATE INDEX rev_text_id_idx ON revision (rev_text_id); + -- Note this upgrade INSERT INTO mediawiki_version (type,mw_version,notes) VALUES ('Upgrade','MWVERSION','Upgrade from older pre 1.10 version THISVERSION aka SVERSION'); -- 2.20.1