LP#1846354: Adjust upgrade script for speed user/miker/consolidate_patron_notes_rebased-upgrade_speed-signoff
authorMike Rylander <mrylander@gmail.com>
Tue, 8 Sep 2020 19:12:06 +0000 (15:12 -0400)
committerMike Rylander <mrylander@gmail.com>
Tue, 8 Sep 2020 19:21:35 +0000 (15:21 -0400)
commit7f9e046e26dc02d500110fba7e0a5bb9cfdd766b
tree36df6f39c225b88476e766c7efcdcf35020c0849
parent14ae074489b3dde4c05104a0b53c9d5a3fe93017
LP#1846354: Adjust upgrade script for speed

This commit makes minor adjustments to the upgrade script to speed it up
in the face of larger data sets.

NOTE: The DO blocks that provided assertion tests during the the upgrade
have been commented out, as they primarily test that the preceding
insert did not break in some way that would have inserted data from the
wrong table into the intermediate staging tables.  They take a very long
time to run in some cases, but are left here for testers to enable in
order to confirm that they would pass in production.

Signed-off-by: Mike Rylander <mrylander@gmail.com>
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.note_and_message_consolidation
docs/RELEASE_NOTES_NEXT/Client/lp1846354_consolidate_patron_notes.adoc