From c8d2f39a4700ce922278135f5b94e7dc45aaed54 Mon Sep 17 00:00:00 2001 From: miker Date: Fri, 20 Jun 2008 18:59:48 +0000 Subject: [PATCH] adding some indexes that are needed for large installations -- beware the speed impact for initial batch loading! git-svn-id: svn://svn.open-ils.org/ILS/trunk@9897 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/030.schema.metabib.sql | 2 ++ 1 file changed, 2 insertions(+) diff --git a/Open-ILS/src/sql/Pg/030.schema.metabib.sql b/Open-ILS/src/sql/Pg/030.schema.metabib.sql index 27f2586618..76ce782c30 100644 --- a/Open-ILS/src/sql/Pg/030.schema.metabib.sql +++ b/Open-ILS/src/sql/Pg/030.schema.metabib.sql @@ -145,6 +145,8 @@ CREATE TABLE metabib.full_rec ( value TEXT NOT NULL, index_vector tsvector NOT NULL ); +CREATE INDEX metabib_full_rec_tag_subfield_idx ON metabib.full_rec (tag,subfield); +CREATE INDEX metabib_full_rec_value_idx ON metabib.full_rec (value); CREATE INDEX metabib_full_rec_record_idx ON metabib.full_rec (record); CREATE TRIGGER metabib_full_rec_fti_trigger BEFORE UPDATE OR INSERT ON metabib.full_rec -- 2.43.2