Speed up 0663 upgrade script
authorThomas Berezansky <tsbere@mvlc.org>
Mon, 9 Jan 2012 18:58:07 +0000 (13:58 -0500)
committerThomas Berezansky <tsbere@mvlc.org>
Wed, 29 Feb 2012 18:41:46 +0000 (13:41 -0500)
commit148c06c17527bac8d37dae5f4d1d9b2ea9011405
tree507d574be327c6c518c18e73789ea24e07923450
parent5b7b588c3e41b522f39c46deb2ba48cc92acf9ea
Speed up 0663 upgrade script

Move update to the end

This ensures most of the rest goes without error first

Disable triggers on the table before doing update

This speeds the update up significantly as we don't need to re-calc the
additional column's new data.

Allow new column to be null (at first) with no default

This allows the column to be added *without* re-writing every row. We still
re-write every row with the update, but at least we aren't doing that
*twice* this way.

And add the not null/default to new column and re-enable triggers as our
last action.

Signed-off-by: Thomas Berezansky <tsbere@mvlc.org>
Signed-off-by: Jason Stephenson <jstephenson@mvlc.org>
Open-ILS/src/sql/Pg/upgrade/0663.schema.archive_circ_stat_cats.sql