From b6e9559d233ac411ebd188b695495d9c6f25fb53 Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Tue, 12 May 2015 15:27:07 -0400 Subject: [PATCH] LP#800706: add index to serial.record_entry.record This patch adds index on the record column of serial.record_entry, which can improve performance when displaying record details pages in databases that have a large number MFHDs. Signed-off-by: Galen Charlton Signed-off-by: Jason Stephenson --- Open-ILS/src/sql/Pg/210.schema.serials.sql | 1 + .../sql/Pg/upgrade/XXXX.schema.index-record-in-sre.sql | 9 +++++++++ 2 files changed, 10 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.schema.index-record-in-sre.sql diff --git a/Open-ILS/src/sql/Pg/210.schema.serials.sql b/Open-ILS/src/sql/Pg/210.schema.serials.sql index 620d57e885..2e5af44f06 100644 --- a/Open-ILS/src/sql/Pg/210.schema.serials.sql +++ b/Open-ILS/src/sql/Pg/210.schema.serials.sql @@ -20,6 +20,7 @@ CREATE TABLE serial.record_entry ( marc TEXT, last_xact_id TEXT NOT NULL ); +CREATE INDEX serial_record_entry_record_idx ON serial.record_entry ( record ); CREATE INDEX serial_record_entry_creator_idx ON serial.record_entry ( creator ); CREATE INDEX serial_record_entry_editor_idx ON serial.record_entry ( editor ); CREATE INDEX serial_record_entry_owning_lib_idx ON serial.record_entry ( owning_lib, deleted ); diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.index-record-in-sre.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.index-record-in-sre.sql new file mode 100644 index 0000000000..aea7e08e5c --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.index-record-in-sre.sql @@ -0,0 +1,9 @@ +-- index serial.record_entry.record + +BEGIN; + +-- SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); + +CREATE INDEX serial_record_entry_record_idx ON serial.record_entry ( record ); + +COMMIT; -- 2.43.2