projects / working / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 81d5551) | patch
LP1778940: Add Indexes to ate.*_output user/stompro/lp1778940_ate_indexes_signoff
authorJason Boyer <jboyer@library.in.gov>
Thu, 28 Jun 2018 18:36:27 +0000 (14:36 -0400)
committerJosh Stompro <stompro@stompro.org>
Fri, 1 Mar 2019 16:17:05 +0000 (10:17 -0600)
commitf7bd1c5c9f3bbf09fa1536369ed72060670c8473
tree780e68099f451ff4ddb8b15c0730edbd95c168bbtree
parent81d5551dd07d55b4be4ae05397d6b7e78571ac9bcommit | 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>
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