1 -- No transaction is required
2 INSERT INTO config.upgrade_log (version) VALUES ('0374'); -- dbs
4 -- Triggers on the vandelay.queued_*_record tables delete entries from
5 -- the associated vandelay.queued_*_record_attr tables based on the record's
6 -- ID; create an index on that column to avoid sequential scans for each
7 -- queued record that is deleted
8 CREATE INDEX queued_bib_record_attr_record_idx ON vandelay.queued_bib_record_attr (record);
9 CREATE INDEX queued_authority_record_attr_record_idx ON vandelay.queued_authority_record_attr (record);
11 -- Avoid sequential scans for queue retrieval operations by providing an
12 -- index on the queue column
13 CREATE INDEX queued_bib_record_queue_idx ON vandelay.queued_bib_record (queue);
14 CREATE INDEX queued_authority_record_queue_idx ON vandelay.queued_authority_record (queue);