LP#1972738: add an ANALYZE after the index gets created
authorGalen Charlton <gmc@equinoxOLI.org>
Mon, 27 Mar 2023 19:52:18 +0000 (15:52 -0400)
committerGalen Charlton <gmc@equinoxOLI.org>
Mon, 27 Mar 2023 19:52:18 +0000 (15:52 -0400)
Signed-off-by: Galen Charlton <gmc@equinoxOLI.org>

Open-ILS/src/sql/Pg/upgrade/XXXX.schema.add-hopeless-date-index.sql

index d07cd40..7ed0399 100644 (file)
@@ -5,3 +5,5 @@ BEGIN;
 CREATE INDEX hold_request_hopeless_date_idx ON action.hold_request (hopeless_date);
 
 COMMIT;
+
+ANALYZE action.hold_request;