LP#1846354: Adjust upgrade script for speed
authorMike Rylander <mrylander@gmail.com>
Tue, 8 Sep 2020 19:12:06 +0000 (15:12 -0400)
committerJason Etheridge <jason@EquinoxInitiative.org>
Fri, 11 Sep 2020 17:36:33 +0000 (13:36 -0400)
commit05f731bc14587b8d600209b6ad975e067afef5a4
tree61ed3e6c5bc2a77e224b2285938d22a9b1719fbf
parent771bff3fcc25273973601e4cae119f57dacbc300
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