Home - Waterfall Grid T-Grid Console Builders Recent Builds Buildslaves Changesources - JSON API - About

Change #6160

Category None
Changed by Jason Boyer <jboyerohnoyoudont@library.in.gov>
Changed at Wed 24 Apr 2019 15:32:09
Repository git://git.evergreen-ils.org/Evergreen.git
Project Evergreen
Branch master
Revision 4491c46ffcecb1f317b1b35ac6afa8c148b50371

Comments

LP1778940: Add Indexes to ate.*_output
When there are many rows in action_trigger.event_output
simply ensuring referencial integrity can take an
unacceptably long time as Postgres has to make sure
that the output being deleted isn't referenced in
any of these 3 fields. Adding these indexes keeps
these checks always fast.

Signed-off-by: Jason Boyer <jboyer@library.in.gov>
Signed-off-by: Josh Stompro <stompro@stompro.org>
Signed-off-by: Galen Charlton <gmc@equinoxinitiative.org>

Changed files