projects / working / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: be1d853) | 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:43:25 +0000 (15:43 -0400)
commit7348a2db080d42115cfd66592a7f6762ba6d8080
tree61aa9a49aba0f50745b9b98270bbbbcc05c912fetree
parentbe1d8530299c164befbe9b36c4220462539ef727commit | 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