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