Change #6160
Category | None |
Changed by | Jason Boyer <jboyer | @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
- Open-ILS/src/sql/Pg/400.schema.action_trigger.sql
- Open-ILS/src/sql/Pg/upgrade/XXXX.schema.ate_outputs_indexes.sql