From a688fb8a29e5203f587f1e393982d607c97a681d Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Tue, 17 Jan 2017 15:09:15 -0500 Subject: [PATCH] LP#1657241 - Add parent_circ index to action.aged_circulation The lack of a parent_circ index on the aged_circulation table was causing very long-running queries. This solves the problem. Signed-off-by: Chris Sharp Signed-off-by: Bill Erickson --- Open-ILS/src/sql/Pg/090.schema.action.sql | 1 + .../XXXX.schema.aged_circulation_parent_circ_idx.sql | 7 +++++++ 2 files changed, 8 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.schema.aged_circulation_parent_circ_idx.sql diff --git a/Open-ILS/src/sql/Pg/090.schema.action.sql b/Open-ILS/src/sql/Pg/090.schema.action.sql index 19e1f1ea1e..923ba4e41c 100644 --- a/Open-ILS/src/sql/Pg/090.schema.action.sql +++ b/Open-ILS/src/sql/Pg/090.schema.action.sql @@ -232,6 +232,7 @@ CREATE INDEX aged_circ_copy_circ_lib_idx ON "action".aged_circulation (copy_circ CREATE INDEX aged_circ_copy_owning_lib_idx ON "action".aged_circulation (copy_owning_lib); CREATE INDEX aged_circ_copy_location_idx ON "action".aged_circulation (copy_location); CREATE INDEX action_aged_circulation_target_copy_idx ON action.aged_circulation (target_copy); +CREATE INDEX action_aged_circulation_parent_circ_idx ON action.aged_circulation (parent_circ); CREATE OR REPLACE VIEW action.all_circulation AS SELECT id,usr_post_code, usr_home_ou, usr_profile, usr_birth_year, copy_call_number, copy_location, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.aged_circulation_parent_circ_idx.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.aged_circulation_parent_circ_idx.sql new file mode 100644 index 0000000000..6d521b94d3 --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.aged_circulation_parent_circ_idx.sql @@ -0,0 +1,7 @@ +BEGIN; + +SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); + +CREATE INDEX action_aged_circulation_parent_circ_idx ON action.aged_circulation (parent_circ); + +COMMIT; -- 2.43.2