projects / working / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 35cf841) | patch
LP1778940: Add Indexes to ate.*_output
authorJason Boyer <jboyer@library.in.gov>
Thu, 28 Jun 2018 18:36:27 +0000 (14:36 -0400)
committerGalen Charlton <gmc@equinoxinitiative.org>
Wed, 24 Apr 2019 19:44:18 +0000 (15:44 -0400)
commit65a11283b628b5cb0b147dd897f1cad276d6553c
tree8700a1495deee11da2bf76d37c09b2c4982ae819tree
parent35cf8413a230b6581571f3f026fdad119a2e593dcommit | diff
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>
Open-ILS/src/sql/Pg/400.schema.action_trigger.sql diff | blob | history
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.ate_outputs_indexes.sql [new file with mode: 0644] blob
Evergreen ILS