LP#1479953: Rename indexes to *_idx and add pgTAP test.
[working/Evergreen.git] / Open-ILS / src / sql / Pg / upgrade / XXXX.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('XXXX', :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;