projects / working / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 25bd5a7) | patch
LP1778940: Add Indexes to ate.*_output user/jboyer/lp1778940_ate_indexes
authorJason Boyer <jboyer@library.in.gov>
Thu, 28 Jun 2018 18:36:27 +0000 (14:36 -0400)
committerJason Boyer <jboyer@library.in.gov>
Thu, 28 Jun 2018 18:36:27 +0000 (14:36 -0400)
commit3b3c4f8deb6104427397e19ccfb77043b812de88
tree9b2dad27705cdf3da1bf3aab8bec578eb011bcfctree
parent25bd5a725f586a84107034c5ba0f3906a7d33b15commit | 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>
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