From 71df266db6b8ba782ef2d4b00032974c44713ce8 Mon Sep 17 00:00:00 2001 From: Jason Stephenson Date: Tue, 10 May 2022 11:07:25 -0400 Subject: [PATCH] LP1972738: Add index on hopeless date Add an index on action.hold_request hopeless_date column to speed up hopeless holds processing. Signed-off-by: Jason Stephenson Signed-off-by: Galen Charlton --- Open-ILS/src/sql/Pg/090.schema.action.sql | 2 +- .../XXXX.schema.add-hopeless-date-index.sql | 7 +++++++ 2 files changed, 8 insertions(+), 1 deletions(-) create mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.schema.add-hopeless-date-index.sql diff --git a/Open-ILS/src/sql/Pg/090.schema.action.sql b/Open-ILS/src/sql/Pg/090.schema.action.sql index 711269e..9051841 100644 --- a/Open-ILS/src/sql/Pg/090.schema.action.sql +++ b/Open-ILS/src/sql/Pg/090.schema.action.sql @@ -526,7 +526,7 @@ CREATE INDEX hold_request_copy_capture_time_idx ON action.hold_request (current_ CREATE INDEX hold_request_open_captured_shelf_lib_idx ON action.hold_request (current_shelf_lib) WHERE capture_time IS NOT NULL AND fulfillment_time IS NULL AND (pickup_lib <> current_shelf_lib); CREATE INDEX hold_fulfillment_time_idx ON action.hold_request (fulfillment_time) WHERE fulfillment_time IS NOT NULL; CREATE INDEX hold_request_time_idx ON action.hold_request (request_time); - +CREATE INDEX hold_request_hopeless_date_idx ON action.hold_request (hopeless_date); CREATE TABLE action.hold_request_note ( diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.add-hopeless-date-index.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.add-hopeless-date-index.sql new file mode 100644 index 0000000..d07cd40 --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.add-hopeless-date-index.sql @@ -0,0 +1,7 @@ +BEGIN; + +--SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); + +CREATE INDEX hold_request_hopeless_date_idx ON action.hold_request (hopeless_date); + +COMMIT; -- 1.7.2.5