From 4d839c4141d255324af8ce29bb1e5c1d61548c44 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Tue, 18 Apr 2017 10:38:29 -0400 Subject: [PATCH] JBAS-1554 Create aged circ index concurrently Signed-off-by: Bill Erickson --- KCLS/sql/schema/deploy/aged-circs-api.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/KCLS/sql/schema/deploy/aged-circs-api.sql b/KCLS/sql/schema/deploy/aged-circs-api.sql index e118d6fc91..2e869ab480 100644 --- a/KCLS/sql/schema/deploy/aged-circs-api.sql +++ b/KCLS/sql/schema/deploy/aged-circs-api.sql @@ -145,6 +145,6 @@ COMMIT; -- create index on parent_circ after main transaction. SET STATEMENT_TIMEOUT = 0; -CREATE INDEX action_aged_circulation_parent_circ_idx +CREATE INDEX CONCURRENTLY action_aged_circulation_parent_circ_idx ON action.aged_circulation (parent_circ); -- 2.11.0