projects / evergreen-equinox.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: e83a8c0) | 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:32:09 +0000 (15:32 -0400)
commit4491c46ffcecb1f317b1b35ac6afa8c148b50371
treee9f114b38dd91b7e061f860776ed86c2bf35d9e4tree | snapshot
parente83a8c001a66ba7378c79c8ccd4451aeb711b956commit | 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 with Equinox developments in process and local tweaks