Wikimedia Bugzilla is closed!

load tsearch (from pg-contrib) into 'tsearch' schema, and create table:

CREATE TABLE "mediawiki"."searchindex" (
  "si_page" INTEGER NOT NULL, 
  "si_title" "tsearch"."tsvector", 
  "si_text" "tsearch"."tsvector"
) WITH OIDS;

CREATE INDEX "si_text_idx" ON "mediawiki"."searchindex"
USING gist ("si_text");

CREATE INDEX "si_title_idx" ON "public"."searchindex"
USING gist ("si_title");