Open-ILS/src/sql/Pg/upgrade/0922.index.queued_record.sql

   1 BEGIN;
   2
   3 /* LP#1479953: Adding indexes to foreign key references to
   4  * vandelay.queued_bib_record will speed up deletions of vqbr records (thereby
   5  * speeding up vandelay.bib_queue deletions).
   6  */
   7
   8 SELECT evergreen.upgrade_deps_block_check('0922', :eg_version);
   9
  10 CREATE INDEX acq_lineitem_history_queued_record_idx ON acq.acq_lineitem_history (queued_record);
  11 CREATE INDEX li_queued_record_idx ON acq.lineitem (queued_record);
  12 CREATE INDEX bib_match_queued_record_idx ON vandelay.bib_match (queued_record);
  13 CREATE INDEX import_item_record_idx ON vandelay.import_item (record);
  14
  15 COMMIT;