LP#1479953: Add indexes to vqbr foreign key references
authorJeff Davis <jdavis@sitka.bclibraries.ca>
Thu, 30 Jul 2015 20:12:35 +0000 (13:12 -0700)
committerJason Stephenson <jstephenson@mvlc.org>
Thu, 6 Aug 2015 15:44:26 +0000 (11:44 -0400)
commit679578d86ecb56885e956ad07a864b2c96808295
tree0db17363776d929464d990aa0d4ff16e06c35fca
parentb8422397ff57cb4f2709db75451db8a97eb19575
LP#1479953: Add indexes to vqbr foreign key references

Deleting a bib queue can be quite slow if it contains many queued
records.  This is because each queued record needs to be deleted, and
this in turn affects many tables that contain unindexed foreign key
references to vandelay.queued_bib_record.  Indexing those foreign keys
can speed up bib queue deletion substantially.

Signed-off-by: Jeff Davis <jdavis@sitka.bclibraries.ca>
Signed-off-by: Kathy Lussier <klussier@masslnc.org>
Signed-off-by: Jason Stephenson <jstephenson@mvlc.org>
Open-ILS/src/sql/Pg/012.schema.vandelay.sql
Open-ILS/src/sql/Pg/200.schema.acq.sql
Open-ILS/src/sql/Pg/201.acq.audit-functions.sql
Open-ILS/src/sql/Pg/upgrade/XXXX.index.queued_record.sql [new file with mode: 0644]