So the confirmation query, that was projected to complete in several days, and was increasing before I stopped it, and was maxing out disk I/O, now completes in 2+15 with minimal disk activity. The remaining performance hotspots are in shared pointer allocation and store critical sections.