From d59afc3677ec622b404a191e56cdbcadec07dea2 Mon Sep 17 00:00:00 2001 From: miker Date: Wed, 21 Jul 2010 15:38:14 +0000 Subject: [PATCH] index which /greatly/ speeds collection of pending active events git-svn-id: svn://svn.open-ils.org/ILS/branches/rel_1_6@16996 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/400.schema.action_trigger.sql | 1 + 1 file changed, 1 insertion(+) diff --git a/Open-ILS/src/sql/Pg/400.schema.action_trigger.sql b/Open-ILS/src/sql/Pg/400.schema.action_trigger.sql index 4db2f591f7..5f85d0eb8a 100644 --- a/Open-ILS/src/sql/Pg/400.schema.action_trigger.sql +++ b/Open-ILS/src/sql/Pg/400.schema.action_trigger.sql @@ -151,6 +151,7 @@ CREATE TABLE action_trigger.event ( template_output BIGINT REFERENCES action_trigger.event_output (id), error_output BIGINT REFERENCES action_trigger.event_output (id) ); +CREATE INDEX atev_target_def_idx ON action_trigger.event (target,event_def); CREATE TABLE action_trigger.event_params ( id BIGSERIAL PRIMARY KEY, -- 2.11.0