From 0e7f80bd692a4e8cd475be9a2d72db09a2dea452 Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Mon, 27 Mar 2023 15:52:18 -0400 Subject: [PATCH] LP#1972738: add an ANALYZE after the index gets created Signed-off-by: Galen Charlton --- Open-ILS/src/sql/Pg/upgrade/XXXX.schema.add-hopeless-date-index.sql | 2 ++ 1 file changed, 2 insertions(+) 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 index d07cd400b4..7ed0399fe4 100644 --- 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 @@ -5,3 +5,5 @@ BEGIN; CREATE INDEX hold_request_hopeless_date_idx ON action.hold_request (hopeless_date); COMMIT; + +ANALYZE action.hold_request; -- 2.11.0