From 9abc8600a859171bdf30a59e589d1ea29e1cf111 Mon Sep 17 00:00:00 2001 From: miker Date: Fri, 20 Jun 2008 19:29:46 +0000 Subject: [PATCH] removing the (value) index, as large records will make Pg unhappy -- fields too large to directly index with the default Pg blocksize git-svn-id: svn://svn.open-ils.org/ILS/trunk@9898 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/030.schema.metabib.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/030.schema.metabib.sql b/Open-ILS/src/sql/Pg/030.schema.metabib.sql index 76ce782c30..342baff2d4 100644 --- a/Open-ILS/src/sql/Pg/030.schema.metabib.sql +++ b/Open-ILS/src/sql/Pg/030.schema.metabib.sql @@ -146,7 +146,7 @@ CREATE TABLE metabib.full_rec ( 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_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