LP#1778940: (follow-up) create indexes concurrently during upgrade
[evergreen-equinox.git] / Open-ILS / src / sql / Pg / upgrade / 1161.schema.ate_outputs_indexes.sql
1 -- No transaction needed. This can be run on a live, production server.
2 SELECT evergreen.upgrade_deps_block_check('1161', :eg_version); -- jboyer/stompro/gmcharlt
3
4 CREATE INDEX CONCURRENTLY atev_template_output ON action_trigger.event (template_output);
5 CREATE INDEX CONCURRENTLY atev_async_output ON action_trigger.event (async_output);
6 CREATE INDEX CONCURRENTLY atev_error_output ON action_trigger.event (error_output);