This SQL (and the other sql like it) seemed like it was hanging, though maybe not. Changed
FROM
update grouper_members gm set subject_resolution_deleted='F' where subject_resolution_deleted is null commit;
TO
update grouper_members gm set subject_resolution_deleted='F' where subject_resolution_deleted is null and gm.id in (select gm2.id from grouper_members gm2 where subject_resolution_deleted is null limit 50000) ; commit; update grouper_members gm set subject_resolution_deleted='F' where subject_resolution_deleted is null and gm.id in (select gm2.id from grouper_members gm2 where subject_resolution_deleted is null limit 50000) ; commit; update grouper_members gm set subject_resolution_deleted='F' where subject_resolution_deleted is null and gm.id in (select gm2.id from grouper_members gm2 where subject_resolution_deleted is null limit 50000) ; commit; ...etc...