LP#1778940: (follow-up) create indexes concurrently during upgrade
[evergreen-equinox.git] / Open-ILS / src / sql / Pg / upgrade / XXXX.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('XXXX', :eg_version);
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);